Go into design mode.
Show the properties for that combobox
Change the LinkedCell property to the address of a cell (out of the way or under
the combobox???)
then use that linked cell in your formula.

=If(a1="Weekly",C20*5,0)
(A1 is my linked cell)

You need double quotes around strings and you don't need =sum() in your
expression.



Chey wrote:

Control Tool Box

"Dave Peterson" wrote:

How did you make the combobox?

Did you use a combobox from the Control toolbox toolbar?
Did you use a dropdown from the Forms toolbar?
Did you use data|validation?



Chey wrote:

I have the list box with the information in it.
When I click on let say Weekly I want a cell in the spreadsheet to
If(ComboBox1 = Weekly, Sum(C20*5),0)

How do I get this to work?

Thanks
Chey

--

Dave Peterson


--

Dave Peterson