Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to give the source value for a combobox on excel spreadsheet Jithu Excel Discussion (Misc queries) 2 May 29th 07 12:50 PM
Excel combobox problem aoeui Excel Discussion (Misc queries) 2 August 25th 05 02:07 AM
creating a combobox dynamically on an excel sheet gupt New Users to Excel 8 June 7th 05 04:07 AM
Combobox - use values in excel formula Nico Excel Worksheet Functions 1 February 2nd 05 09:22 AM
how do i insert a combobox in excel LYNNSKIN Excel Worksheet Functions 1 January 13th 05 08:49 PM


All times are GMT +1. The time now is 02:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"