+ Reply to Thread
Results 1 to 3 of 3

Executing a Macro with Variable Name from String

  1. #1
    Registered User
    Join Date
    08-21-2013
    Location
    Canberra, Australia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Exclamation Executing a Macro with Variable Name from String

    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.
    Last edited by zeuscartwright; 08-22-2013 at 01:45 AM. Reason: Sovled

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Executing a Macro with Variable Name from String

    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.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    08-21-2013
    Location
    Canberra, Australia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Executing a Macro with Variable Name from String

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] insert variable string in email macro
    By ag273n in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2013, 06:47 PM
  2. Replies: 4
    Last Post: 07-12-2013, 12:14 PM
  3. Macro to open files based on string variable
    By Coeus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-11-2013, 06:47 PM
  4. Transferring a dynamically named string variable to another string variable.
    By Concorde Rules in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-09-2012, 04:08 AM
  5. Passing String Variable from Command Button Macro to a List Box in same User Form
    By wz4np1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2012, 11:31 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1