Addin Hook Events

Author: Dave
Date: 04.10.14 - 4:39am

Ok this is kind of cool and I couldnt find any examples to it online, but I figured it would be valid.

The VB6 Addin model allows you to enumerate all of the menus and toolbar buttons in the IDE. You can get their caption, and execute them based on a reference you obtain from enumeration.

It also stood to reason, that if you can get a reference to them, you can also hook into their events and be notified when the user clicks them.

I was looking for:

a way to automatically click the default Make menu since I didnt like the behavior of the MakeCompiledFile API
a way to be notified when the user hit the Run toolbar icon to start debugging so I could clear the immediate window.

Turns out both are possible :)

Dim mcbRealStartButton As Office.CommandBarControl
Private WithEvents mnuRealRun As CommandBarEvents 'hook into existing controls events

Set mcbRealStartButton = FindRunButton()
If Not mcbRealStartButton Is Nothing Then
      Set mnuRealRun = VBInstance.Events.CommandBarEvents(mcbRealStartButton)
End If

Private Sub mnuRealRun_Click(ByVal CommandBarControl As Object, handled As Boolean, CancelDefault As Boolean)
    If ClearImmediateOnStart = 1 Then
       On Error Resume Next
       Dim oWindow As VBIDE.Window
       Set oWindow = VBInstance.ActiveWindow
       VBInstance.Windows("Immediate").SetFocus
       SendKeys "^{Home}", True
       SendKeys "^+{End}", True
       SendKeys "{Del}", True
       oWindow.SetFocus
    End If
End Sub

Private Function FindRunButton() As Office.CommandBarControl
    
    Dim cbToolbar As Office.CommandBar
    Dim cbSubMenu As Office.CommandBarControl
    
    For Each cbToolbar In VBInstance.CommandBars
        'Debug.Print "Toolbar: " & cbToolbar.Index
        'If cbToolbar.Index = 17 Then Stop
        For Each cbSubMenu In cbToolbar.Controls
            'Debug.Print vbTab & cbSubMenu.caption
            If cbSubMenu.caption = "&Start" Then
                Set FindRunButton = cbSubMenu
                Exit Function
            End If
        Next
    Next
    
End Function





Comments: (1)
On 04.24.14 - 4:53am Dave wrote:
turns out there is a dark side to this trick..the IDE automatically disables all addin buttons when it enters run mode. 



Apparently this extends to existing buttons whose events you tap into as well...



slightly annoying but not critical, Looking for a solution..


    	
	
	 
	Leave Comment:
	 
	Name: 
	Email: (not shown) 
	Message: (Required) 
	Math Question:  93 + 30 = ? followed by the letter: I