+ Reply to Thread
Results 1 to 4 of 4

Exit Previous User Form

  1. #1
    Forum Contributor
    Join Date
    09-18-2014
    Location
    Pakistan
    MS-Off Ver
    2013, 2016
    Posts
    283

    Exit Previous User Form

    Hi.
    I have two User Form in Excel.
    When I Press close button from 1st then it shows 2nd user form.

    from 2nd user form I press print preview button.
    That show me print preview of that file.

    But problem is this print preview come then 1st user form till there. I am unable to see the print preview.

    Please give me the code that exit 1st form also and show me print preview.

    Thanks

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,199

    Re: Exit Previous User Form

    Hi, AmirSoft,

    you could try either
    Please Login or Register  to view this content.
    which will let the UF stay in memory for further action or
    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    Best practise would be to post your code instead of asking us to write it for you.

    Ciao,
    Hoilger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Exit Previous User Form

    Hi,

    If Userform1 is still there then it sounds like your Close button on UF1 is not closing the UF. Is it perhaps just hiding it?

    Use

    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Contributor
    Join Date
    09-18-2014
    Location
    Pakistan
    MS-Off Ver
    2013, 2016
    Posts
    283

    Re: Exit Previous User Form

    Just Debug Error

    Nothing Else

+ 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. Find next and previous record through user form
    By nami1pk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-21-2014, 05:53 AM
  2. next and previous record on user form
    By adil mehboob in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2014, 01:53 AM
  3. Validation not allowing user to exit form
    By Damian37 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-03-2014, 11:02 AM
  4. Save and exit workbook when user form closes
    By savio21 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2011, 11:21 AM
  5. Exit sub from user form problem...
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-10-2008, 10:54 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