Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to use combo box controls to control columns selection?
Hi, all,
Normally Excel combo box is used for selecting line by line, could be a possible to use it to select column by column? If not, which kind form controls could be realized? Thanks in advanced, Zhou Zhen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to use combo box controls to control columns selection?
Since the value property of the combobox is tied to the bound column
property, you would have to find a way to switch the bound column property with each selection across columns. The question is, is it really worth it when the as built functionality works? If you just want a horizontal list of options, you could use labels on a UserForm, or individual option buttons lined up from left to right. "Zhou Zhen" wrote: Hi, all, Normally Excel combo box is used for selecting line by line, could be a possible to use it to select column by column? If not, which kind form controls could be realized? Thanks in advanced, Zhou Zhen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box selection only shows bound column info after selection made. | Excel Programming | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
No change event on control toolbox combo box when selection is the same? | Excel Programming | |||
Problem hiding/unhiding columns using combo control | Excel Programming |