Hi can anyone help?
I have a CommandButton12 that calls CommandButton1 multiple times. Sheet2
eg
CommandButton1 calls different Sub routines.
If I want to call CommandButton1 five times or ten times or any other amount of times, I have to go back into the code and add the required amount of calls.
Would it be possible to add a dropdown list or form on Sheet2 to choose the required amount of calls between 1 to 100 for CommandButton1.
Any help would be apprieciated
Regards
pwill
I have a CommandButton12 that calls CommandButton1 multiple times. Sheet2
eg
Code:
Private Sub CommandButton12_Click()
Call CommandButton1_Click
Call CommandButton1_Click
Call CommandButton1_Click
End Sub
CommandButton1 calls different Sub routines.
If I want to call CommandButton1 five times or ten times or any other amount of times, I have to go back into the code and add the required amount of calls.
Would it be possible to add a dropdown list or form on Sheet2 to choose the required amount of calls between 1 to 100 for CommandButton1.
Any help would be apprieciated
Regards
pwill
Last edited: