Executing a Macro with Variable Name from String

**zeuscartwright** · 08-22-2013, 01:25 AM

Hi Again Team,

I'm trying to execute a macro based on the value of a string.

Does anyone know how this could be done?

I have this so far:

Please Login or Register  to view this content.

**romperstomper** · 08-22-2013, 01:37 AM

Please Login or Register  to view this content.

should work, although I'm not sure what your macro would do that didn't involve loading the form, which you then do again.

**zeuscartwright** · 08-22-2013, 01:43 AM

Thanks for that Rory,

It either preloads the form with data or opens it as a fresh one.

Also changes some titles here and there depending on why the form is being opened.

For example, adding a new user or updating an existing users details.

Executing a Macro with Variable Name from String

LinkBack

Thread Tools

Rate This Thread

Display

Executing a Macro with Variable Name from String

Re: Executing a Macro with Variable Name from String

Re: Executing a Macro with Variable Name from String

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] insert variable string in email macro

Adding a variable string comment to a cell. "Object Variable or WIth Block Variable Not.."

Macro to open files based on string variable

Transferring a dynamically named string variable to another string variable.

Passing String Variable from Command Button Macro to a List Box in same User Form

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions