Form Dropdown: click event macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.Caller)

Thank you very much for any assistance!
Carolyn
 
in the vbe, click on the object browser button to make it visible. Right
click on it and select show hidden members

then you can see what properties they have.
 
Thank you very much Tom! You've helped me once again.

Funny. I had guessed DropDown and DropDowns, but must have made a typo
because I got an error originally. Now the macros is working.

And thank you for that object browser info. This helps immensely.

Carolyn
 
Back
Top