Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Combobox
If you used a combobox from the Control toolbox toolbar, you can go into design
mode and rightclick on the combobox. Then choose properties and assign the .linkedcell property to a cell and add that value to your formula. =sum(e4:e9)+x99 (change x99 to whatever cell's address you used. Parkforester wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Combobox
Thanks Dave. However when I put the cell address of e10 into the linkedcell
property, which is where my combobox is located. I get error message: "Could not set the value property. Invalid property value." My listfillrange is l3:l7. Can you explain what I'm doing wrong? "Dave Peterson" wrote: If you used a combobox from the Control toolbox toolbar, you can go into design mode and rightclick on the combobox. Then choose properties and assign the .linkedcell property to a cell and add that value to your formula. =sum(e4:e9)+x99 (change x99 to whatever cell's address you used. Parkforester wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Combobox
It sounds like you did it ok. I'd try it again.
Are you sure you used 13:17 as the listfillrange? Parkforester wrote: Thanks Dave. However when I put the cell address of e10 into the linkedcell property, which is where my combobox is located. I get error message: "Could not set the value property. Invalid property value." My listfillrange is l3:l7. Can you explain what I'm doing wrong? "Dave Peterson" wrote: If you used a combobox from the Control toolbox toolbar, you can go into design mode and rightclick on the combobox. Then choose properties and assign the .linkedcell property to a cell and add that value to your formula. =sum(e4:e9)+x99 (change x99 to whatever cell's address you used. Parkforester wrote: 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 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to give the source value for a combobox on excel spreadsheet | Excel Discussion (Misc queries) | |||
Excel combobox problem | Excel Discussion (Misc queries) | |||
creating a combobox dynamically on an excel sheet | New Users to Excel | |||
Combobox - use values in excel formula | Excel Worksheet Functions | |||
how do i insert a combobox in excel | Excel Worksheet Functions |