+ Reply to Thread
Results 1 to 4 of 4

close form after 'Yes'

  1. #1
    Registered User
    Join Date
    05-25-2017
    Location
    Perth, Australia
    MS-Off Ver
    2010
    Posts
    18

    close form after 'Yes'

    Hi,

    how am I to close the user form after I have clicked yes?

    Thanks in advance

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: close form after 'Yes'

    code:

    Please Login or Register  to view this content.

  3. #3
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: close form after 'Yes'

    Hi,

    It would be simply
    Please Login or Register  to view this content.
    (a userform does not have a close method)
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  4. #4
    Registered User
    Join Date
    05-25-2017
    Location
    Perth, Australia
    MS-Off Ver
    2010
    Posts
    18

    Re: close form after 'Yes'

    Thanks for that! easy

+ 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. [SOLVED] Close form with ESC button
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2012, 10:02 AM
  2. Password to be able to close a form
    By Zheno in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2011, 04:52 PM
  3. close a form
    By fozze in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2008, 10:30 AM
  4. open and close form
    By tomro1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2006, 04:54 AM
  5. Close form...
    By pianoman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-05-2006, 09:09 AM
  6. [SOLVED] close .chm with form
    By ckoch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2006, 02:55 PM
  7. User Form... built in form is so close...!
    By pianoman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2006, 08:01 AM
  8. Close Switchboard Form
    By ca1358 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2006, 05:40 PM

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