Randomize a module with a sub of calling other subs.

[0o0o0]

Basically I have

Sub example()

Call Another module.sub1

Call Another module2.sub2

Call Another module3.sub3

Call Another module4.sub4

Call Another module5.sub5

End Sub

now if ran you know above runs 1 then 2 then 3 then 4 then 5 done..

Is there a page or link I could go to to show me how to create it to completely randomly pick 5 2 3 4 1 or 3 1 2 5 4 or any way it wants to randomize

BUT! it has to by the end when its finished have ran all 5 regardless the order. All 5 must be ran.

Thanks for any input.

[Marc L]

See CallByName function in VBA inner help …

[Sintek]

Try something like this...
In A1:A5 ... 1 2 3 4 5

Please Login or Register  to view this content.

[xlnitwit]

You'd need to use Application.Run since Callbyname only works with objects (modules don't count).

Here's a simple method as you only have 5 to choose from

Please Login or Register  to view this content.

[0o0o0]

xlnitwit I have 51 lol..

so is this the method?

Please Login or Register  to view this content.

almost solved! lemme know and thanks all.

[xlnitwit]

It won’t work for that many. May I ask why you need to do this?

[0o0o0]

i have a list of runners....

and its the very same order every single day.

So I want it to randomize instead and never have the same order of sequence.

[0o0o0]

sintek's is looking promising.. trying it now for 51

[0o0o0]

Yep did the trick sintek thanks!

SOLVED

[Sintek]

Glad I could contribute. Tx for rep +

[xlnitwit]

I'm glad it's resolved but I can't see any need for 51 different macros from your description!

[Sintek]

I was wondering the same thing...Why wanting to run so many macros...Perhaps OP can clarify and we can come up with a simplistic solution...