Microsoft® Excel® based database addin

 
+ Reply to Thread
Results 1 to 3 of 3
  1. 03-11-2010 06:30 PM #1
    BillCPA Guest

    Default VBE Toolbars and Windows

    I know you can reference the different VB windows with VB code - is there
    some way to reference the toolbars in the VB Editor window?

    Also, the whole, overall window that appears when you enter the VB Editor -
    is this the '....VBE.MainWindow'?

    --
    Bill @ UAMS
    Reply With Quote Reply With Quote  
  2. 03-11-2010 07:02 PM #2
    Peter T Guest

    Default Re: VBE Toolbars and Windows

    "BillCPA" <Bill @ UAMS> wrote in message

    >I know you can reference the different VB windows with VB code - is there
    > some way to reference the toolbars in the VB Editor window?

    Dim objVBE As VBE
    Dim cbr As CommandBar
    Set objVBE = Excel.Application.VBE
    Set bars = objVBE.CommandBars
    For Each cbr In objVBE.CommandBars
    Debug.Print cbr.Name
    Next
    Set cbr = objVBE.CommandBars("Menu Bar")
    Debug.Print cbr.Name


    > Also, the whole, overall window that appears when you enter the VB
    > Editor -
    > is this the '....VBE.MainWindow'?

    Yes
    also look at
    For Each W in objVBE.Windows

    Regards,
    Peter T


    Reply With Quote Reply With Quote  
  3. 03-11-2010 10:01 PM #3
    Chip Pearson Guest

    Default Re: VBE Toolbars and Windows

    Application.VBE.CommandBars is the root of all command and menu bars
    in the VBA Editor. Yes, Application.VBE.MainWindow is the editor's
    main application window.

    Cordially,
    Chip Pearson
    Microsoft MVP 1998 - 2010
    Pearson Software Consulting, LLC
    www.cpearson.com
    [email on web site]




    On Thu, 11 Mar 2010 11:07:01 -0800, BillCPA <Bill @ UAMS> wrote:

    >I know you can reference the different VB windows with VB code - is there
    >some way to reference the toolbars in the VB Editor window?
    >
    >Also, the whole, overall window that appears when you enter the VB Editor -
    >is this the '....VBE.MainWindow'?
    Reply With Quote Reply With Quote  
« Previous Thread | Next Thread »

Similar Threads

  1. VBE and Arranging Windows
    By Bishop in forum Programming (VBA, VB, C# etc)
    Replies: 2
    Last Post: 08-13-2009, 03:30 PM
  2. Undockable windows in VBE
    By CQX Ray in forum Excel Setup
    Replies: 1
    Last Post: 08-05-2009, 08:31 AM
  3. Code from Powerpoint VBE not Working in Excel VBE?
    By Aaron in forum Programming (VBA, VB, C# etc)
    Replies: 1
    Last Post: 03-14-2009, 01:38 AM
  4. VBE Windows
    By Stratuser in forum Programming (VBA, VB, C# etc)
    Replies: 2
    Last Post: 01-21-2009, 09:01 PM
  5. Please Help, No Toolbars in my view->toolbars!
    By Badtaste2k@gmail.com in forum Programming (VBA, VB, C# etc)
    Replies: 2
    Last Post: 01-21-2009, 06:07 PM

Bookmarks

Posting Permissions

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

Forum Rules