Thread: Excel Combobox
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Parkforester Parkforester is offline
external usenet poster
 
Posts: 2
Default Excel Combobox

Hi

I wish to sum a list of numbers with one of them being a combobox. The list
is 42,500 + 332,500 + 532,000 + 212,800 + 30,500 with the fourth one being a
combobox with values in it of 90,000 to 110,000. What I want is everytime you
change the value in the combobox the Total formula wil recalculate to the new
total? I have so far =sum(e4:e9). How do I put the combobox in the formula
=sum(e4:e9).

Thanks

John