Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox Control on Worksheet
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox Control on Worksheet
On May 14, 11:39 am, wrote:
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!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox Control on Worksheet
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 " wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
form control combobox | Excel Discussion (Misc queries) | |||
Control ToolBox ComboBox | Excel Discussion (Misc queries) | |||
Dim CTL as MSForms.Control always sets as Control/Combobox | Excel Programming | |||
combobox control how to's? | Excel Programming | |||
Excel Combobox Box Control | Excel Programming |