Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I am using the Forms toolbar and am buidling click event macros. Does anyone have a list of object "names" as called in the two sample VB lines below? Specifically, right now I need this for the DropDown combo box. But I would appreciate any more too. For DropDown: Dim myDrpDwn As DropDown '??? Is DropDown correct? I'm getting no error. Set myDrpDwn = ActiveSheet.?????(Application.Caller) For CheckBoxes: Dim myCBX As CheckBox Set myCBX = ActiveSheet.CheckBoxes(Application.Caller) For Radio Buttons (aka Option Buttons): Dim OptBtn as OptionButton Set OptBtn=ActiveSheet.OptionButtons(Application.Calle r) Thank you very much for any assistance! Carolyn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Right Click Dropdown | Excel Discussion (Misc queries) | |||
userform label double-click goes to click event | Excel Programming | |||
Passing CheckBox Value from Click Event to Main Macro | Excel Programming | |||
user form-on open event? keydown event? | Excel Programming | |||
Click event on cell triggers a macro | Excel Programming |