Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a combobox that I generated through the toolbox. My code looks as such: Private Sub ComboBox1_Change() With Me.ComboBox1.TopLeftCell ..Offset(0, 5) = "NI" ..Offset(0, 6) = "UT" ..Offset(0, 7) = "ZAT" ..Offset(0, 8) = "ZB" ..Offset(0, 9) = "ZA" ..Offset(0, 10) = "Z1A" The name of the combobox is "General" anytime I drop down this combobox to make an item selection ( which produces the list above), the list desired does come up, however I want to make it so that whenever Im done looking at the generated list, I can go to the combobox and be able to select the original title of the combobox; "General" and eliminate/delete my list. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ComboBox drop list when clicked on??????????? | Excel Discussion (Misc queries) | |||
Combobox drop down | Excel Discussion (Misc queries) | |||
Combobox drop down | Excel Discussion (Misc queries) | |||
drop-down / combobox in a custom toolbar | Excel Programming | |||
combobox to drop 'up' not down | Excel Programming |