VBIDE Window existence/visibility
In another forum, I've noticed that some seem to want to know how to detect the existence/visibility of the VBIDE window, so here's how.
[VBA]
Option Explicit
Public Sub CheckVBEWindowState()
Dim strBuffer As String
With Application.VBE.MainWindow
Select Case .WindowState
Case vbext_ws_Maximize
strBuffer = "VBE window state is maximize"
Case vbext_ws_Minimize
strBuffer = "VBE window state is minimize"
Case vbext_ws_Normal
strBuffer = "VBE window state is normal (window has not been opened)"
End Select
strBuffer = strBuffer & vbCrLf & "and window is " & IIf(.Visible, "", "not ") & "visible."
End With
MsgBox strBuffer
End Sub
[/VBA]
