Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combo boxes and AutoSum
What function would I use to add a range of numbers that includes a combo
box? I tried AutoSum but the Total doesn't recalculate when I change the number in the combo box. Thanks so much! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combo boxes and AutoSum
Do you have the combo box linked to a cell?
A combo box does not occupy a cell, it "floats" on top of the worksheet. If you have the combo box linked to a cell the linked cell will return the *index number* of the selected item. Depending on what numbers you have as selections for the combo box, you then have to associate the selection index number with the actual value of the selected number. For example, if you have these numbers as selections for the combo box: 10 20 30 If you select 10 the linked cell will return 1. 10 is the first item in the list so it has an index number of 1. 20 is the second item in the list so it has an index number of 2. 30 is the third item in the list so it has an index number of 3. So, you'd have to convert those index numbers to their actual values. It's not difficult but you'd have to provide more detailed info as to what the numbers are and *where* they're located as the source for the combo box. -- Biff Microsoft Excel MVP "sc" wrote in message ... What function would I use to add a range of numbers that includes a combo box? I tried AutoSum but the Total doesn't recalculate when I change the number in the combo box. Thanks so much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Boxes | Excel Discussion (Misc queries) | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
combo boxes | Excel Discussion (Misc queries) | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel |