Excel-Combo box

[Guest]

I want to have a combo box in my excel spreadsheet. The problem is that I
need to have two columns; however, when I create it, I just have the values
in the first column. Is there any way I can have my combo box that shows the
values for both columns? For instance, I have column A that has code numbers
and a column B that has the description of the codes. When I create my combo
box, I would like to click in the drop down arrow and see the code as well as
the description. However, when I choose the code, I would like to show just
the code on my cell.

 

[Guest]

I'm not sure with a form combo box, but you can using a combo box from the
control toolbox.

Once you have drawn it and placed it on the screen, right mouse click,
select properties, look for ListFillRange, you can put your cells range
there.

You can link your cell using LinkedCell

To test, click exit design menu button on control toolbox.

 

[Guest]

I tried that, but it didn't work. Even though I select the two columns with
the informaiton, only one is shown when I click on the drop down arrow.

 

[Guest]

Sorry Gloria, if you go back into the properties for the combo box, look for
ColumnCount and change the number to the number of colums your looking at.

ie 2 to look at a range of cells in two columns

 

[Guest]

When I go to properties, the only options I have are: input range, cell link
and drop down lines. I don't see columncount. Can you tell me where it is?
Thanks

 

[Guest]

Hi Gloria,

The combobox your using must be from the forms toolbar,

Click View on the menu bar,
Then Toolbars,
Then check the one that says control toolbox.

Should should now see another set of tools. (This can be dragged and docked
on to your menus so its always there.)

Use the combobox from this menu, and follows notes from before.

This should then give you the result you was after.

 

[Guest]

Thanks for your help.

Hi Gloria,

The combobox your using must be from the forms toolbar,

Click View on the menu bar,
Then Toolbars,
Then check the one that says control toolbox.

Should should now see another set of tools. (This can be dragged and docked
on to your menus so its always there.)

Use the combobox from this menu, and follows notes from before.

This should then give you the result you was after.