Run in the same form

[Mat N]

I want to "Run" a procedure in my form by referencing the string that
represents the procedure.

I think Run is the right function to use however it throws me an error
that it can't find the procedure.

Example:

For the button on the form:

Private Sub cmdProcessList_Click()
RunProcedurefromString
End Sub

Public Sub RunProcedurefromString()
Run "TheProcedure" '<--This is where the error occurs
End Sub

Public Sub TheProcedure()
MsgBox "if this shows then Run is doing what I think it should",
vbOKOnly, "It Works!"
End Sub

Can anyone tell me what I'm doing wrong? And/or a better approach.

Thanks

[Keith]

"Mat N" <Ma******@gmail.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...

Public Sub RunProcedurefromString()
Run "TheProcedure" '<--This is where the error occurs
End Sub

Try 'Call' or even just the sub's name.

Keith.
www.keithwilby.com

[Mat N]

To use Call and just the sub name however would work but I wouldn't
referring to the procedure using a string.

ie

TheProcedure

or

Call TheProcedure

would work however:

"TheProcedure"

or

Call "TheProcedure"

Would not and all I have is the string that represents the Procedure
name.

Why am I using a string you may ask. Well for the sake of argument you
can assume that I'm pulling names of the procedures from a table.

[Lyle Fairfield]

Mat N wrote:

To use Call and just the sub name however would work but I wouldn't
referring to the procedure using a string.

Application.Run "TheProcedureName", Arg1, Arg2, etc (or no args)

or just

Run "TheProcedureName" Arg1, Arg2, etc (or no args)

Make the procedure a Public Function, not a Public Sub.

BTW, this is required for running code from a macro as well; must be,
TTBOMK, a function, not a sub.

--
--
Lyle

"The aim of those who try to control thought is always the same. They
find one single explanation of the world, one system of thought and
action that will (they believe) cover everything; and then they try to
impose that on all thinking people."
- Gilbert Highet

[Gary Floam]

Hi,

I think you want the Eval method.

Gary

"Mat N" <Ma******@gmail.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...

I want to "Run" a procedure in my form by referencing the string that
represents the procedure.

I think Run is the right function to use however it throws me an error
that it can't find the procedure.

Example:

For the button on the form:

Private Sub cmdProcessList_Click()
RunProcedurefromString
End Sub

Public Sub RunProcedurefromString()
Run "TheProcedure" '<--This is where the error occurs
End Sub

Public Sub TheProcedure()
MsgBox "if this shows then Run is doing what I think it should",
vbOKOnly, "It Works!"
End Sub

Can anyone tell me what I'm doing wrong? And/or a better approach.

Thanks

[Mat N]

I tried the eval method without success.

I've done a less elegant fix to the problem for the time being.

Lyle, when I have a moment I will try out your suggest although I think
I may have already given it a go without success.

Thanks