command buttons

[pwill]

Hi can anyone help?

I have a CommandButton12 that calls CommandButton1 multiple times. Sheet2

eg

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

 

[My Aswer Is This]

I'm sorry but when I saw your original post it looked like a simple task.
So I provide a script to do that.
But now it sounds like you may want to click one command button that will run hundreds of script in hundreds of buttons all at the click of one button. And some scripts you may want to run more then once.

And just looking at one of your scripts shows these are not simple little scripts.

I believe you could find this difficult to do.

But there are a lot of other people on this forum smarter then me so hopefully someone else here will be able to help you.
I will continue to monitor this thread.

 

[pwill]

Hi My Aswer Is This, you underestimate yourself,

I have just ran your code and it is exactly what I was after actually better because I was thinking maybe a dropdown list with a scroll action but your code allows me to just enter what I like, much more convienent thank you for your patients much apprieciated.

Regards

pwill

 

[My Aswer Is This]

Glad I was able to help you.