VBA Tutorial Login  

Free! Excel VBA Online Tutorial

   

Excel VBA

Excel UserForm Controls - ScrollBar and SpinButton; create Mortgage Calculator using ScrollBar

User Rating:  / 14
PoorBest 
Details

Article Index

 

UserForm Controls - ScrollBar and SpinButton

 

 

UserForm acts as a container in which you add multiple ActiveX controls, each of which has a specific use and associated properties. By itself, a UserForm will not be of much use unless ActiveX controls are added to it which are the actual user-interactive objects. Using ActiveX Controls on a Worksheet have been illustrated in detail, in the separate section of "Excel VBA: ActiveX Controls, Form Controls & AutoShapes on a Worksheet".

 

Also refer "2. UserForm and Controls - Properties" for properties common to the UserForm and most Controls

Note: In below given examples, vba codes are required to be entered in the Code Module of the UserForm, unless specified otherwise.

 

   

Bottom Ad

   
© 2014 GlobaliConnect.com. All rights reserved.