Variable in Function name

[Jaamie]

I have several functions named Test1(), Test2(), ..., etc.

I want to be able to say If TestX() = True then ...

How can I accomplish going to one particular test at run time based on the value of X?

Thank you,
Jim..

 

[villy]

If Application.Run("Test" & x) Then

You got it...
that was what I'm searching for Application.Run..
works for me

 

[Jaamie]

It messed up my indentations in the code making it hard to read. How do I fix that?

Also, is there a way to view or find my posts?

Thanks,
Jim

 

[Jaamie]

The application.run worked.

Thank you,
Jim..

 

[Ruddles]

if "test" & X &"()" = true then
this just fell through to the next statement

It would, because this is like saying If "test1()" = True.[/QUOTE]

If Evaluate("Test" & x & "()") Then
went to some random place.

Odd, it worked here when tested. Ah well, I see you have a solution.

 

[Ruddles]

It messed up my indentations in the code making it hard to read. How do I fix that?

Always post code between CODE tages - the # icon in the advanced editor toolbar.

Also, is there a way to view or find my posts?

Go to the top of the screen where it says "Welcome, Jaamie" and click your name, then go Statistics > View all posts.