Please Note: This article is written for users of the following Microsoft Word versions: 97, 2000, 2002, and 2003. If you are using a later version (Word 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Word, click here: Detecting an Open Dialog Box.

Detecting an Open Dialog Box

by Allen Wyatt
(last updated February 5, 2018)

2

Thomas has a macro that performs various functions at timed intervals. Some of those functions should not be performed if a dialog box is open on the screen, because trying to perform them will cause an error in the functions. He wonders if there is some way, within the macro, to detect if a dialog box—any dialog box—is currently open. Thomas would rather detect the open dialog box rather than deal with a generated error.

Perhaps the only way to attempt to do this is to use FindWindow, which is actually part of the Windows API. Its purpose is to retrieve a handle to a particular open window. (A dialog box is nothing but an open window, and each dialog box has a name.) This approach won't tell you if any dialog box is open, but it will tell you if a specific dialog box is open.

Here is a quick example to show how the FindWindow function can be used:

Declare Function FindWindow Lib "user32" Alias "FindWindowA" _
  (ByVal wClassName As Any, ByVal wWindowName As String) As Long

Sub testDialogOpen()
    Dim wHandle As Long
    Dim wName As String

    wName = "Find and Replace"
    wHandle = FindWindow(0&, wName)
    If wHandle = 0 Then
        MsgBox "Dialog window is not open"
    Else
        MsgBox "Dialog window is open"
    End If
End Sub

Note that the FindWindow function needs to be declared outside of your VBA procedure. Then, within the procedure, you need to specify the name of the dialog box you want to find out about. This is the name that appears in the title bar for the dialog box, and the FindWindow function is case insensitive. The return value for FindWindow will be a handle for the dialog box, if it is open. If it is not open, then the function returns a 0.

Remember, too, that dialog boxes can be of two types: modal and non-modal. If a particular dialog box is modal, then it must be dismissed before any other actions can be taken on the system. You'll want to do extensive testing with the dialog boxes at point, as you may get different performance from your macro depending on whether an open dialog box is modal or not.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (12355) applies to Microsoft Word 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Detecting an Open Dialog Box.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Big File Memory Blues

Excel places limits on how much memory your workbooks can use. Despite these limits, it is possible to create a workbook ...

Discover More

Contingent Validation Lists

Data validation can be used to create lists of choices for entry into a particular cell. Using the techniques in this tip ...

Discover More

Printing a Bookmark List

Need to know what bookmarks are defined in a document? Here's a macro that creates a list of all your bookmarks so that ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More WordTips (menu)

Running Macros from Macros

Need to run one macro from within another macro? You can easily do it by using the Run method of the Application object, ...

Discover More

Inserting a Paragraph from within a Macro

Macros are often used to process documents, resulting in changes of one manner or another. If you need your macro to add ...

Discover More

Getting User Input in a Dialog Box

Want to grab some interactive input from a user in your macro? The best way to do that is with the InputBox function, ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is five more than 7?

2012-12-15 01:55:30

Tom Stevens

Big oops - Non-existing names do NOT generate an error!


2012-12-15 01:53:53

Tom Stevens

One more example of the power of API calls. This code can be easily converted to a generic function testing whether any dialog with the passed name is open. Non-existing dialog names do generate an error.


This Site

Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.