Control Number - A better way
I use something similar to this in a lot of userforms and was hoping that
there might be a better way.
Scenario.......
I want to pass the number of the CommandButton clicked to another sub.
How I do it now......
Private Sub CBClick()
' Do stuff here based on the BoxClicked Number
End Sub
Private Sub CommandButton1_Click()
BoxClicked = 1
CBClick
End Sub
Private Sub CommandButton2_Click()
BoxClicked = 2
CBClick
End Sub
' continued for another 97 Command Buttons
Private Sub CommandButton99_Click()
BoxClicked = 99
CBClick
End Sub
Is there a better way?????
Thanks,
John
|