Good Day, all. Here's what I'm trying to do.
I have a Userform with several option buttons. As the user selects one option button, other option buttons are Enabled depending on the user's choice. No problem here. At a point in the process when the user makes a particular choice, I want the all of the rest of the controls to be Enabled, EXCEPT the controls not previously chosen.
In other words, when the user makes a choice, the other options in that group are disabled, so that the user can easily see which choices were made.
My approach has been to create a variable to receive the option button name as it's selected. Then turn on all controls. Then loop back through all the controls on the Userform, comparing them to the items in the variable containing the previously selected controls. If the control is not in the previously selected group, turn it off.
In other words, I want to turn on all of the controls which were not previously disabled. Maybe there is a better way to do this. I'm definitely open to suggestions
I have a Userform with several option buttons. As the user selects one option button, other option buttons are Enabled depending on the user's choice. No problem here. At a point in the process when the user makes a particular choice, I want the all of the rest of the controls to be Enabled, EXCEPT the controls not previously chosen.
In other words, when the user makes a choice, the other options in that group are disabled, so that the user can easily see which choices were made.
My approach has been to create a variable to receive the option button name as it's selected. Then turn on all controls. Then loop back through all the controls on the Userform, comparing them to the items in the variable containing the previously selected controls. If the control is not in the previously selected group, turn it off.
In other words, I want to turn on all of the controls which were not previously disabled. Maybe there is a better way to do this. I'm definitely open to suggestions