Combo box will not give me an actual number

martijnvanderveldt

New member
Joined
Sep 10, 2014
Messages
10
Reaction score
0
Points
0
He guys!

I am making a questionaire in Excel and am using the comboboxes to make a rating. The ratings go from 1 to 12 and i assigned the outcomes to different cells. And though all numbers show up in the cells i assigned them to, i can't use them for anything in a formula. For example, if i try to sum them up =SUM(H13:H24), it will say 0 even though it should be 78. I need to use each rating since they are used in different options later.

Probably an easy one, but i can't figure it out

Thanks in advance!
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,200
Reaction score
16
Points
38
Excel Version(s)
365
Several solutions to this one.
1. Change the formula to an array-entered (ctrl+shift+Enter, otherwise you'll get a #Value) =SUM(VALUE(H13:H24))
2. It looks like you're using activex combo boxes, try using Forms comboboxes instead. It'll give you the index of the selected item.
3. If you stick with activex, make the listfillrange 2 columns wide (the second column containing the numbers), and change the boundcolumn property to 2
 
Top