Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combo Box selection to place $0 into another cell
I am trying to use a combo box to select a text item from the list, once I
select this text item, I want it to place a $0 into another cell. example: I select from combo box - Teriyaki Chicken, then I want $7.00 to appear in cell C8 which will in turn be used to calculate a total based on several other cells. I just need to know how to take the text from the combo box in cell A8 and place a dollar figure $7.00 in cell C8. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
Is it possible to re-link a cell back to a combo box? | Excel Discussion (Misc queries) | |||
Can I copy a combo box in Excel 2002 with a relative cell link? | Excel Discussion (Misc queries) | |||
How can I set up the random selection of a cell from within a ran. | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |