Combo box will not give me an actual number

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!

I used the following code to make the combobox:

Private Sub Workbook_open()

With Sheet2.ComboBox1

.AddItem "1"
.AddItem "2"
.AddItem "3"
.AddItem "4"
.AddItem "5"
.AddItem "6"
.AddItem "7"
.AddItem "8"
.AddItem "9"
.AddItem "10"
.AddItem "11"
.AddItem "12"

End With

Maybe i did something wrong here?
Besides that i just assigned the combobox to a cell. They still show 1,2..12 in the cells. but they seem useless.

I'm not exactly an expert, but I just tried what you're talking about - when populating the combobox, I just used CDbl
So

Please Login or Register  to view this content.

It worked fine for me - adding, multiplying, whatever numerically oriented functions I tried were fine.