Variable procedure call

Hi,

Does anyone know if I can, during runtime, call a procedure with a variable
name? For example, I'd like to pass a parameter to a calling procedure, and
then based on that parameter call another procedure. I'm sure I cheat and do
it with a select statement, but I'd like to do it more directly if possible.

Thanks,

Art

dim myStr as string
mystr = "Sub1"
application.run "'" & thisworkbook.name & "'!" & mystr





Art wrote:
>
> Hi,
>
> Does anyone know if I can, during runtime, call a procedure with a variable
> name? For example, I'd like to pass a parameter to a calling procedure, and
> then based on that parameter call another procedure. I'm sure I cheat and do
> it with a select statement, but I'd like to do it more directly if possible.
>
> Thanks,
>
> Art

--

Dave Peterson

Dave - FANTASTIC!

I really needed to do this, but frankly thought it couldn't be done. I
figured I had nothing to lose by asking. This is great! This will really
simplify a bunch of stuff in my application.

Thanks,

Art

"Dave Peterson" wrote:

> dim myStr as string
> mystr = "Sub1"
> application.run "'" & thisworkbook.name & "'!" & mystr
>
>
>
>
>
> Art wrote:
> >
> > Hi,
> >
> > Does anyone know if I can, during runtime, call a procedure with a variable
> > name? For example, I'd like to pass a parameter to a calling procedure, and
> > then based on that parameter call another procedure. I'm sure I cheat and do
> > it with a select statement, but I'd like to do it more directly if possible.
> >
> > Thanks,
> >
> > Art
>
> --
>
> Dave Peterson
>