Results 1 to 7 of 7

getting Form Object from form name

Threaded View

foxguy getting Form Object from form... 08-31-2010, 05:01 PM
Leith Ross Re: getting Form Object from... 08-31-2010, 07:19 PM
foxguy Re: getting Form Object from... 08-31-2010, 07:52 PM
Leith Ross Re: getting Form Object from... 08-31-2010, 07:56 PM
MarvinP Re: getting Form Object from... 08-31-2010, 09:40 PM
Leith Ross Re: getting Form Object from... 08-31-2010, 09:56 PM
MarvinP Re: getting Form Object from... 08-31-2010, 10:28 PM
  1. #1
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    getting Form Object from form name

    I'm trying to create a sub that will initiate a form by passing it the form's name. I thought that "Evaluate" would be the way to go, but I can't get it to work.
    Sub Edit_Form( sMyForm As String)
    
        Dim oForm as Object
    
        Set oForm = New Evaluate(sMyForm)
        oForm.Show
    End Sub
    Last edited by foxguy; 09-01-2010 at 12:03 PM.
    Foxguy

    Remember to mark your questions [Solved] and rate the answer(s)
    Forum Rules are Here

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