MrExcel Publishing
Your One Stop for Excel Tips & Solutions

combo box


Posted by ali on September 11, 2001 9:01 AM

in data base i have to use a combo box , but don't know how. i want to insert the words, budget, standard adn deluxe. so when the i click on the button i get the list. however when i select a catorgory i want the price to show in the next cell.eg: so once i have selected the budget the price will show for £9.95.

price to display
the list should be; budget 9.95
stanadrd 12'95
deluxe 15.95

please help. this is amjor task for my GCSE prject

thank u


Posted by Juan Pablo on September 11, 2001 9:23 AM

I don't know if this can help you, but i think it's the most simple way to do that.

In Cell A1 (OR where you want to put the combobox), select Data - Validation, List (Make sure that Cell with list is checked) and in the Origin box write:

Budget,Standard,Deluxe

No spaces, and commas between the words.

And then click Ok, you should have the combo box. Now, the second part, in cell A2 write this formula:

=IF(A1="Budget",9.95,IF(A1="Standard",12.95,IF(A1="Deluxe",15.95,""),""),"")

And that should do it...

Hope that helps

Juan Pablo price to display