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

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