Skip to main content

Application.ActiveWindow property

Table of contents
  1. Syntax
  2. Example

Returns a Window object that represents the active Excel window (the window on top). Returns Nothing if there are no windows open. Read-only.



expression A variable that represents an Application object.


This example displays the name (Caption property) of the active Excel window.

MsgBox "The name of the active window is " & ActiveWindow.Caption

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>