Excel VBA – ActiveX Controls, Form Controls & AutoShapes on a Worksheet ———————————————————————————————– Contents: Forms in Excel ActiveX controls, Form controls & AutoShapes in an Excel Worksheet Shape object & OLEObject object ActiveX Controls in VBA Add an ActiveX Control, a Form Control or an AutoShape, in Worksheet Illustrating Form Controls, ActiveX Controls & AutoShapes:...
Tag: Label
Excel UserForm Controls – Image and RefEdit; use LoadPicture property with GetOpenFilename Method
UserForm Controls – Image and RefEdit 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...
Excel UserForm Controls – ScrollBar and SpinButton; create Mortgage Calculator using ScrollBar
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...
Excel UserForm Controls – Frame, MultiPage and TabStrip; group OptionButtons; create a wizard using MultiPage control
UserForm Controls – Frame, MultiPage and TabStrip 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...
Excel UserForm Controls – ComboBox and ListBox: AddItem Method, BoundColumn, List Property, ListIndex, RowSource, Selected Property, …
UserForm Controls – ComboBox and ListBox ———————————————————- Contents: Difference between ListBox and ComboBox Key Properties of ComboBox and ListBox Add Items/Data to (Populate) a ListBox or ComboBox Extract ListBox & ComboBox Items, with VBA Delete ListBox rows using the RemoveItem Method ———————————————————- UserForm acts as a container in which you add multiple...
Excel UserForm and Controls – Properties; Setting control properties at design-time or run-time.
UserForm and Controls – Properties ———————————————————————- Contents: UserForm and Controls Basic Properties common to the UserForm and most Controls Other Properties common to the UserForm and most Controls Specifying Color in Properties Window Applicability of Properties to UserForm and its Controls – A SnapShot ———————————————————————- UserForm acts as a container in which...
UserForms in Excel VBA – UserForm Basics; Add Controls dynamically at run-time using the Add Method; UserForm Controls (A Snapshot)
UserForms in Excel VBA – UserForm Basics; Add Controls dynamically at run-time using the Add Method; UserForm Controls (A Snapshot) ———————————————————————– Contents: Excel UserForms Create a UserForm UserForm Controls – A SnapShot UserForm Basics Add Controls to a UserForm ———————————————————————– Note: In below given examples, vba codes are required to be entered in the Code...