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

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

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

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