+ Reply to Thread
Results 1 to 2 of 2

Exit Userform to return to main code, but keep userform open

  1. #1
    Registered User
    Join Date
    09-04-2014
    Location
    Bristol
    MS-Off Ver
    2010
    Posts
    0

    Exit Userform to return to main code, but keep userform open

    Hello,

    I am trying to exit my userform and return to the looping in my main VBA code module, but I cannot seem to be able to do this without closing the userform.

    The code in my main VBA code module is looping and will keep updating the variables used for my userform, but I am trying to avoid having to keep hiding and unhiding the userform as it causes flashing.

    Any ideas anyone?

    Many thanks in advance.

    Lee

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello jombler74,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Date picker UserForm to stay always in front of the main UserForm
    By Gabor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2014, 07:31 AM
  2. UserForm help - display list of open workbooks except workbook userform code is in
    By kensweep in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-09-2014, 12:26 PM
  3. [SOLVED] Open a userform from a userform, but preserve the info in the original userform
    By jfoerch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2013, 02:38 PM
  4. Want to Hide a UserForm source book while keeping main XL workbook open...
    By MBlaster in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2012, 05:52 PM
  5. [SOLVED] Looping procedure calls userform; how to exit loop (via userform button)?
    By KR in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-27-2005, 08:05 AM

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