Combo Box

[ajx1220]

I've been fighting with this all day. What I am trying to do is to get a drop down that when one of the options is selected it populated 2 other values into 2 other cells. Lets say I have a drop down of cars. GMC Envoy, Toyota Highlander, Hummer H2. I want the user of the spreadsheet to be able to select GMC Envoy and have the MSRP populate in one cell and the Invoice price populate in another cell. I cannot figure this out for the life of me and any help would be appreciated. Thanks

[Leith Ross]

Hello ajx1220,

This can be accomplished easily using a Control Toolbox combobox, since it supports multiple columns. I assume this combobox is on a worksheet and not a VBA UserForm. If not, let me know. Do you have the cars and prices listed on a worksheet in individual lists? If so, what are the cell ranges you are using?

Sincerely,
Leith Ross

[ajx1220]

I just used the cars as an example. I have a sheet in the workbook that has what would be the models, the MSRP, and the Invoice all in columns. A is Models, B is MSRP, C is Invoice. I need A to be the only thing in the combo box and when the model is selected I need B and C to populate in two seperate cells.

[Leith Ross]

Hello ajx1220,

Not a problem. The ComboBox can display only column and hide the others. When the user makes their selection, the Click event of the combo can then load the other cells with the hidden data from the ComboBox. Give me a few minutes and I can code up and example for you.

Sincerely,
Leith Ross

[ajx1220]

Thanks, I think I found a solution. =INDEX(A2:A4, C5) using this I can take the numeric output from the Combo Box and have it referenced to populate the 2 fields I need filled. It's messy but will do. Unless you have a cleaner solution that doesnt require me hiding things in plain sight.

[ajx1220]

Also, I need help figuring out how to have multiple options selected and have a dollar value for the multiple options calculated in a different cell. I was thinking check boxes or list box. For example, I'll need a box for apples , bananas, pears, and grapes. In a seperate sheet (Sheet 3) I have a table. Column A is apples, bananas, pears, and grapes, and Column B is the price for these items. I need the items selected on Sheet 1 and the dollar amount for each item selected calculated into a cell on Sheet 1 pulling the prices from Sheet 3.