Quote:
I guess that means Private Sub OptionButton1_Change() is now Private Sub NextGen_Change(), etc.
|
and changed without any dramas.
Quote:
That negates use of the For i = 1 to 3 loops to establish sheet and Optionbutton names.
|
have commented out the above bits of code for the time being.
Quote:
In place of the loops write 3 lines for sheets and 3 lines for optionbuttons each using the actual name.
|
You've completely lost me - I'm afraid that I really need some assistance with what you mean.
Quote:
Also change the sheet names accordingly elsewhere within the code.
|
Figured that would be the case but thanks for jogging my cold laden brain.