I have a series of five option buttons, in a group, in a worksheet. These are form objects, not active x. The value for the selected cell returns a value of 1 to 5 depending on user selection. The cell link with that value is on the same sheet (cell XFD1). if the user selects option button 11 or option button 12 (the first and second buttons), i want Rows 31 and 32 to be visible. The following code, assigned to the first option button, makes that happen. i have a comparable sub for Option Button 12 that also works will also make the rows visible, as desired.
I am trying to anticipate a situation where the user wrongly selects either of the first two options (displaying the two rows), then corrects the error by then selecting button 3, 4 or 5. When this occurs, i need rows 31:32 to be hidden.
I have tried similar code for the third through fifth option buttons with the above sub, substituting
Any suggestions would be appreciated.