Hi to all in forum,
Having many activex buttons, I want to generate the code shown below to have all activex buttons associated
with macro "Calculate" and put that needed codde automatically inside sheet1 module.
Private Sub CommandButton1_Click() Call Calculate End Sub Private Sub CommandButton2_Click() Call Calculate End Sub . . . Private Sub CommandButton80_Click() Call Calculate End Sub
So, is needed to get the name of each button (CommandButtonX) to generate each "Private" Sub Routine and be
able to take each sub routine to sheet1 module.
I hope make sense and somebody could help me.
Any help would be very appreciated.