Results 1 to 2 of 2

Thread: Combo box will not give me an actual number

  1. #1

    Combo box will not give me an actual number



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,502
    Articles
    0
    Excel Version
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •