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: TextBox
Excel UserForm Controls – CheckBox, OptionButton and ToggleButton
UserForm Controls – CheckBox, OptionButton and ToggleButton 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....
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...