Form Dropdown: click event macro

[Carolyn]

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

 

[Tom Ogilvy]

Listbox
spinner
scrollbar
textbox
groupbox
label
editbox
dropdown
optionbutton
checkbox

 

[Tom Ogilvy]

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.

 

[Carolyn]

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