Assign a linked cell to that combobox and then just use regular excel.

=a1*a2

(where a1 is the linked cell and a2 is the "normal" cell.)

John wrote:

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.

--

Dave Peterson