how to use combo box controls to control columns selection?

[Zhou Zhen]

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

 

[JLGWhiz]

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.