Hello to all the coding superstars out there!
I have created a Userform with a few different sections enabled or disabled based on questions answered on the previous tab.
Capture.PNG
What I'm trying to do is make the "Next" button become enabled if the user has completed all the enabled fields above, while ignoring any disabled fields. The problem I keep coming up against is how to code all the different combinations of options. So like, if section A is enabled and section B,C, and D are not, then the user would only have to complete open fields in section A, however if section A and B are enabled, but C and D are not, then they would need to complete both sections, and so on...
I started with your basic If/Then statement to account for all the different combinations, but I have to believe there is a better way to deal with this type of coding logic. What do you all think would be the most efficient way to achieve what I'm trying to do?
Many thanks for your suggestions!
Bookmarks