psychedelic109
New Member
- Joined
- May 12, 2011
- Messages
- 1
Hi,
I'm creating an excel-based request form and I'm trying to mandate certain form fields/cells depending on which option button my customers select. For example:
Possible choices are:
Option 1, Option 2 and Option 3
Each option corresponds to a particular section of the form.
So, if my customer selects Option 1, how do I make the form fields/cells in the section for Option 1 be mandatory? If Option 1 is selected, cells for Option 2 and 3 should not be tagged as mandatory and customer can exit the form without receiving any pop-up box telling them that the fields are mandatory and he/she cannot close the form.
Appreciate if you can assist me with this.
I'm not well-versed with vba, so it would be good if you guys can share codes that I can use to make this form work.
Thank you!
I'm creating an excel-based request form and I'm trying to mandate certain form fields/cells depending on which option button my customers select. For example:
Possible choices are:
Option 1, Option 2 and Option 3
Each option corresponds to a particular section of the form.
So, if my customer selects Option 1, how do I make the form fields/cells in the section for Option 1 be mandatory? If Option 1 is selected, cells for Option 2 and 3 should not be tagged as mandatory and customer can exit the form without receiving any pop-up box telling them that the fields are mandatory and he/she cannot close the form.
Appreciate if you can assist me with this.
I'm not well-versed with vba, so it would be good if you guys can share codes that I can use to make this form work. Thank you!
