Calling a sub method

[richcoleuk]

Hi,

I have the name of my sub method stored in a variable:

mySubMethodName = "do_something"

I then want to call this method using the variable, I have tried
the following but it doesn't work:

Call mySubMethodName

Is there anyway to do what I am trying to do?

[Christian]

richcoleuk wrote:
> Hi,
>
> I have the name of my sub method stored in a variable:
>
> mySubMethodName = "do_something"
>
> I then want to call this method using the variable, I have tried
> the following but it doesn't work:
>
> Call mySubMethodName
>
> Is there anyway to do what I am trying to do?
>
>
> --
> richcoleuk
> ------------------------------------------------------------------------
> richcoleuk's Profile: http://www.excelforum.com/member.php...o&userid=33103
> View this thread: http://www.excelforum.com/showthread...hreadid=549375


Why don't you just use

Call do_something

Christian

[richcoleuk]

because the name of the sub method is specified on the worksheet, and this value is taken from the sheet.

[NickHK]

richcoleuk,
Application.Run ?

NickHK

"richcoleuk" <[email protected]> wrote
in message news:[email protected]...
>
> Hi,
>
> I have the name of my sub method stored in a variable:
>
> mySubMethodName = "do_something"
>
> I then want to call this method using the variable, I have tried
> the following but it doesn't work:
>
> Call mySubMethodName
>
> Is there anyway to do what I am trying to do?
>
>
> --
> richcoleuk
> ------------------------------------------------------------------------
> richcoleuk's Profile:
http://www.excelforum.com/member.php...o&userid=33103
> View this thread: http://www.excelforum.com/showthread...hreadid=549375
>

[richcoleuk]

Works a charm, thanks Nick

[Bob Phillips]

Application.Run variable_name

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"richcoleuk" <[email protected]> wrote
in message news:[email protected]...
>
> because the name of the sub method is specified on the worksheet, and
> this value is taken from the sheet.
>
>
> --
> richcoleuk
> ------------------------------------------------------------------------
> richcoleuk's Profile:
http://www.excelforum.com/member.php...o&userid=33103
> View this thread: http://www.excelforum.com/showthread...hreadid=549375
>