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
|