Hi

I would like to know how to compute the combo box & normal cell.

For example: -

drop down combo box value 20 x normal cell 10
= result cell

Pls kindly advice me

JOHN Kyaw

"John" wrote:

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.