View Single Post
 
Old 06-09-2019, 04:34 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

I guess that means Private Sub OptionButton1_Change() is now Private Sub NextGen_Change(), etc.

That negates use of the For i = 1 to 3 loops to establish sheet and Optionbutton names.
In place of the loops write 3 lines for sheets and 3 lines for optionbuttons each using the actual name.
Also change the sheet names accordingly elsewhere within the code.
Reply With Quote