How can I make an option button invisible and disable it?

  • Profile Image
    Asked on September 15, 2014 at 05:36 AM


    I would like to offer a set of options (Option 1) to the users on an Excel 2013 form but only if another option (Option 2) has been selected to allow that. If Option 2 does not allow selection from Option 1 I do not want to display Option 1 (and do not want to allow selection within Option 1, assuming making them invisible does not mean automatically the disabling of their use). I am a novice in VBA, but could build-in a code if someone could give a hint. I saw codes including { and } but they do not look to be VBA to me (I may be wrong). Thanks for your help in advance.

  • Profile Image
    Answered on September 15, 2014 at 09:00 AM

    Hello George,

    Do you want to achieve this in your JotForm or you want to write a VBA for excel? When you say "Option 1/ Option 2", it is a drop down field, a check box field or a radio button field?

    I am not sure about the VBA code but it is not possible to remove or hide any option from your JotForm. Please be noted that it is possible to hide the question itself but not its option.

    You can take advantage of our "Condition" feature to show hide form fields based on the answer of another form field. You will have to add two fields where one will have Option 1 and another will have option 2. Please check the screenshot below:

    You need to add conditions to check the selection of one field and based on the answer you can show the field with either option 1 and option 2. 

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!