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