Form Dropdown: click event macro
 

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

Form Dropdown: click event macro
 

Listbox
spinner
scrollbar
textbox
groupbox
label
editbox
dropdown
optionbutton
checkbox

--
Regards,
Tom Ogilvy


"Carolyn" wrote:

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

Form Dropdown: click event macro
 

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.

--
Regards,
Tom Ogilvy


"Carolyn" wrote:

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

Form Dropdown: click event macro
 

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