Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Close Msgbox After X Seconds

  1. #1
    Join Date
    4th January 2008
    Posts
    4

    Close Msgbox After X Seconds

    I simply need the code to automatically close a msgbox after 3 seconds.

    I am just trying to create a popup that will inform the user that the processing is complete without having them to click the OK button. Thanks.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    12th September 2006
    Location
    The Great State of Texas
    Posts
    4,322

    Re: Autoclose Msgbox After X Number Of Seconds

    There may (probably is) some way to do close a MsgBox with Windows API, but nothing short of that.

    In the alternative, you could pop up a form that looks like a MsgBox, and write code to close (Unload or Hide) it using the Application.OnTime method. Search for OnTime here in the forum.
    Entia non sunt multiplicanda sine necessitate.
    MS MVP - Excel

  3. #3
    Join Date
    4th January 2008
    Posts
    4

    Re: Autoclose Msgbox After X Number Of Seconds

    Thanks for your help. I ended up utilizing the how-to:

    Excel VBA Macro- How to Create a Splash Screen for your Excel Workbook

    but instead of typing UserForm1.Show in ThisWorkbook, I just put it after the code I wrote in my module.

    Thanks again and I hope this helps others as well.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    12th September 2006
    Location
    The Great State of Texas
    Posts
    4,322

    Re: Autoclose Msgbox After X Number Of Seconds

    Good job, and thanks for posting back.
    Entia non sunt multiplicanda sine necessitate.
    MS MVP - Excel

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 7
    Last Post: April 27th, 2012, 20:04
  2. Replies: 4
    Last Post: September 25th, 2007, 01:16
  3. Msgbox After Automatic Workbook Close
    By dmcbride01 in forum EXCEL HELP
    Replies: 5
    Last Post: April 12th, 2007, 05:59
  4. Replies: 4
    Last Post: March 24th, 2007, 03:36
  5. excel 2000 documents close after a few seconds on the screen
    By Inquiringmind in forum Excel and/or Word Help
    Replies: 12
    Last Post: February 12th, 2003, 08:12

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
  •  
porno