ComboBox Control on Worksheet

[jasonluciano]

Hi All,

I have added a combobox to a worksheet but it doesn't seem to show up
in the VBA editor in the auto help/fill. I can't even reference it by
typing the name any where in the code. Am I missing something? Thanks
for any help.

 

[jasonluciano]

Hi All,

I have added a combobox to a worksheet but it doesn't seem to show up
in the VBA editor in the auto help/fill. I can't even reference it by
typing the name any where in the code. Am I missing something? Thanks
for any help.

Nevermind!!

 

[Guest]

Jason,

If you are referencing it from ThisWorkbook or a user module, you will need
to include the name of the Sheet Object. For example, if it is embedded in
Sheet1 then it would be Sheet1.ComboBox1 (or the specific name of your combo
box control).

You should see the name directly if you are referencing it from the Sheet
object that has the control.

hope that helps,
dan