how to use combo box controls to control columns selection?

  • Thread starter Thread starter Zhou Zhen
  • Start date Start date
Z

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
 
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.
 
Back
Top