View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PJ Murph[_2_] PJ Murph[_2_] is offline
external usenet poster
 
Posts: 19
Default Simplifying numerous checkbox procedures into 1 procedure

I have 400 checkboxes (beginning with cbCheck1 thru cbCheck400). How do I
write code that doesn't have to repeat this procedure 400 times?

Private Sub cbCheck1_Click()
Select Case cbCheck1.Value
Case True: LblOnHold1.Visible = True: LblOnHold1.PrintObject = True
Case False: LblOnHold1.Visible = False: LblOnHold1.PrintObject = False
End Select
End Sub