Call Event and Load Form based on Variable

Hi all,
I have some problem with dynamic things :
1) I need to call an event which the event name was saved in a
variable.
Eg :
Dim sEventName as String
sEventName = "Button1_Click"

Call sEventName

2) And how to load Form based on variable too?
Eg :
Dim sFormName as String
sFormName = "Form1"

Load sFormName

Hope someone can help me to solve the problems.

Thanks a lot!

Resant

use Application.run

Application.Run sEventName


http://support.microsoft.com/kb/157609/en-us
XL97: How to Display a UserForm Whose Name Is in a Variable

--
Regards,
Tom Ogilvy




"Resant" <[email protected]> wrote in message
news:[email protected]...
> Hi all,
> I have some problem with dynamic things :
> 1) I need to call an event which the event name was saved in a
> variable.
> Eg :
> Dim sEventName as String
> sEventName = "Button1_Click"
>
> Call sEventName
>
> 2) And how to load Form based on variable too?
> Eg :
> Dim sFormName as String
> sFormName = "Form1"
>
> Load sFormName
>
> Hope someone can help me to solve the problems.
>
> Thanks a lot!
>
> Resant
>

Wonderful!
You save my time...
Thanks a lot Tom

Tom,
More question....
Is there any coding that could tell what the last macro that have been
run from other Workbook?

Thanks,

Resant

Not Unless you have the macro write that information someplace where you can
access it; there is no built in support for it.

--
Regards,
Tom Ogilvy

"Resant" wrote:

> Tom,
> More question....
> Is there any coding that could tell what the last macro that have been
> run from other Workbook?
>
> Thanks,
>
> Resant
>
>