+ Reply to Thread
Results 1 to 2 of 2

MsgBox remains visible after OK

  1. #1
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    278

    MsgBox remains visible after OK

    A UserForm is open to make selections
    On "Go" button click, I have an if statement that basically says
    if this is true and this is blank Then
    MsgBox "you must select bla bla"
    Exit Sub
    end if

    It exits back to the open userform, but the msgbox does not go away - it just hangs there and you can't click ok or close it.
    Edit: May have to do with screen updating is off?
    Any ideas on how to close or at least hide the msgbox on ok?

    Thanks!
    Last edited by ker9; 05-04-2012 at 10:24 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,485

    Re: MsgBox remains visible after OK

    The message box will clear itself.
    If you have screenupdating off then you could try

    Please Login or Register  to view this content.
    I was not able to replicate a problem with userform/msgbox and screen updating off, so if you are still stuck you may need to post example file.
    Cheers
    Andy
    www.andypope.info

+ 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