Macro call dependent on value

[Throughstream]

Hi I would like to have a click button which runs different macros dependent on the value of a cell.

so
Sub Button3_Click()

If worksheet "rota" cell M29= 1 then call test1
M29= 2 then call test2
M29= 3 then call test3
M29= 4 then call test4

Sub Test1()
code I will write
End Sub
Sub Test2()
code I will write
End Sub

for each of the tests.

Thanks

[JLGWhiz]

Please Login or Register  to view this content.

Be sure your called macros are in one of the numbered code modules for public access.

[Throughstream]

Thank you so much.

Just as a sub question:

I already have a test style vba

Please Login or Register  to view this content.

I want to make the code you gave me as part of test 2 on the above code.

Can you have a test within a test. If it's not simple I'll start a separate thread.

Cheers

[JLGWhiz]

You can, but you have to be careful not to create a perpetual loop of procedure calls by not having one of them eventually meet the condition that bypasses the call to the other marcro. In other words, they couldc conceivably sit there and call each other continually because neither of them contain code to change any of the conditions.