Excel Developer Home > Excel Object Model Reference > Application Object > Properties
Returns a Window object that represents the active window (the window on top). Read-only. Returns Nothing if there are no windows open.

expression.ActiveWindow

expression   A variable that represents an Application object.

Example

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

Visual Basic for Applications
MsgBox "The name of the active window is " & ActiveWindow.Caption

See Also