Results 1 to 2 of 2

Calling routine with name stored in string variable

Threaded View

  1. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Dynamic VBA program

    Sub snb()
      j=1
      application.run "macro_" & j
    End sub
    or
    Sub snb_002()
      sn=array("macro1","macro2","macro_3")
      application.run sn(2)
    End Sub
    Last edited by snb; 05-16-2011 at 12:09 PM.



Thread Information

Users Browsing this Thread

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

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