The following example uses the Caption property to display the caption of the active window.
Debug.Print Application.VBE.ActiveWindow.Caption