Forum Discussion

Andrew_RW's avatar
Andrew_RW
Copper Contributor
Aug 13, 2020

Using form controls

I'm having difficulties using a control form box. I am trying to give 4 options for each of 20 questions with each answer giving a different score in each question. I can't seem to make the control b...
excel
wumolad's avatar
wumolad
Iron Contributor
Aug 13, 2020

Andrew_RW 

 

There is only 1 option button in the file, what did you say was the issue in the initial message?

    • mathetes's avatar
      mathetes
      Gold Contributor
      Aug 13, 2020

      Andrew_RW 

       

      How about an option that doesn't require VBA. Just uses Data Validation for the drop down, and then a simple formula to put the 1 in the appropriate box. Here's the formula I put in cell D3 in the attached (I deleted the macro-dependent rows since this was just a demo):

      =IF($B3=D$2,1,0)

      That formula, copied to all the other relevant cells, compares the answer selected with the column heading.

       

      I will admit to being biased against macros. There are times when they may be essential, but it's often possible to create a simpler and equally effective solution with Excel's pre-existing functions (and a smaller file to boot).

      • Andrew_RW's avatar
        Andrew_RW
        Copper Contributor
        Aug 13, 2020

        Thanks mathetes 

        I'll give that a try. I appreciate your help.

  • Andrew_RW's avatar
    Andrew_RW
    Copper Contributor
    Aug 13, 2020

    Hi wumolad 

    I have 20 questions for which I have 4 options for each question. I am trying to get one set of 4 options for each question but every time I try to start a new set of control boxes for a new question it links with the previous 4 control boxes. When I try to start a new option box it says 'Option Box 33' etc

    Any ideas?

Resources