ComboBox with 2 columns

[Stuart Grant]

In access a combo box can have two or more columns.
Is this possible in Excel. If so how ?
Stuart

 

[Ryan.Chowdhury]

You'll want to use the Combo Box from the Control Toolbox. Then set
the properties accordingly as you would have in access (columncount =
2, etc.).

 

[Stuart Grant]

Thanks for the clear answer. I'm using John Walkenbach's Enhanced Data form
where he creates combo boxes through code. I'm not quite sure how to do
that. His code says
Set NewControl =CurrentFrame.Controls.add("forms.combobox.1")
Do you think "forms.combobox.2" would do it ?

Stuart

 

[Ryan.Chowdhury]

Click View > Toolbars > Control Toolbox. You can select the combo box
from there. I'm not sure what JW's form does. Are you creating a
combo box on a form in VB or on a spreadsheet?

 

[Stuart Grant]

JW's Enhanced Data Form is a free download - xla file - from his web site.
It offers some extra features and convenience, compared to Excel's built in
Data Form. You can get access to the code for, I think, $20, which I paid.
The code is quite educational. He constructs the form to suit whatever data
you have on your Excel spreadsheet and creates text boxes for the fields,
but automartically creates a combobox instead of a text box if there is a
named range with the name of the field. Quite smart !

I'm not really sure how to alter his code to create a 2-column combo, which
I particularly want. Maybe I would be better to create my own form from
scratch, perhaps using some of his ideas. Then I could incorporate a combo
from the Control Toolbox as you suggest.

Thanks for your help.

Stuart