Thread: List Box
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Chey Chey is offline
external usenet poster
 
Posts: 52
Default List Box

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