View Single Post
 
Old 06-09-2019, 06:56 PM
kiwimtnbkr kiwimtnbkr is offline Windows 10 Office 2010 64bit
Advanced Beginner
 
Join Date: Oct 2017
Posts: 69
kiwimtnbkr is on a distinguished road
Default

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.
Reply With Quote