Code for Many check boxes
Below is code I am now using per row, per
check box. How can it be written to do the same thing 10 to 20 times without writing the same code per row for each check box 10 to 20 times? Using a starting check box number and ending with a higher check box number. Private Sub CheckBox2_Click() With CheckBox2 If .Value = True Then Worksheets(2).Range("A9:C9").Value = ActiveSheet.Range("A9:C9").Value Else Worksheets(2).Range("A9:C9").Value = "" End If End With End Sub Thanks for your help |
All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com