What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

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

    Asked by George  on September 15, 2014 at 05:36 AM

    Hi,

    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.

    and excel Selection selected hint
  • Profile Image
    JotForm Support

    Answered by ashwin_d 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!