+ Reply to Thread
Results 1 to 2 of 2

Flow of control from UserForm to Sheet1 sub

  1. #1
    excelnut1954
    Guest

    Flow of control from UserForm to Sheet1 sub

    At the end of my coding in a UserForm, I want the macro to go to a sub
    named Test1 in Sheet1, and continue. What's the proper syntax to have
    the macro look in Sheet 1 for this sub?

    Thanks,
    excelnut


  2. #2
    Bob Phillips
    Guest

    Re: Flow of control from UserForm to Sheet1 sub

    In the code that opens the userform, follow that by a call to the macro

    Userform1.Show
    myMacro

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "excelnut1954" <[email protected]> wrote in message
    news:[email protected]...
    > At the end of my coding in a UserForm, I want the macro to go to a sub
    > named Test1 in Sheet1, and continue. What's the proper syntax to have
    > the macro look in Sheet 1 for this sub?
    >
    > Thanks,
    > excelnut
    >




+ Reply to Thread

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