Consulting

Results 1 to 4 of 4

Thread: VBIDE Window existence/visibility

  1. #1
    VBAX Mentor
    Joined
    Sep 2004
    Location
    Nashua, NH, USA
    Posts
    489
    Location

    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]

  2. #2
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Can you make a kb entry on this?

  3. #3
    VBAX Mentor
    Joined
    Sep 2004
    Location
    Nashua, NH, USA
    Posts
    489
    Location
    Quote Originally Posted by DRJ
    Can you make a kb entry on this?
    I'll try.
    Never done it bee4.

  4. #4
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Let me know if you need any help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •