PDA

View Full Version : Excel's Visual Basic Editor Window



Erdin? E. Ka
12-05-2008, 05:02 AM
Hi all, :hi:

I need to have a list of the all menu names, symbols and shortcut keys of Excel 2003's Visual Basic Editor Window...

Example of the list:
Main Menu Name - Option - Symbol - Shortcut
File - Save Book1 - {Disket Image} - CTRL + S
...
...
...
Help - About Visual Basic - . - .

{ And if it possible; I need a list of Right Click Menu in VBE like above... }


Thanks in advance... :friends:

Erdin? E. Ka
12-09-2008, 05:49 AM
any ideas?

malik641
12-09-2008, 05:51 AM
Hey Erdinc,

I didn't want to post this yet, but I want to show you that I was working on it:

Public Sub getMenuDetails()
Dim ctr1 As Object
Dim ctr2 As Object
Dim str As String
On Error Resume Next
For Each ctr1 In Application.VBE.CommandBars("Menu Bar").Controls
For Each ctr2 In ctr1.Controls
If (ctr2.Visible = True) Then
str = str & "Menu: " & ctr1.Caption & " | Name: " & ctr2.Caption & " | Shortcut: " & ctr2.ShortcutText & vbNewLine
End If
Next ctr2
Debug.Print str
Next ctr1
End Sub


That's all I have so far, but I ran out of time the other day. I'd like to try to finish this up tonight/tomorrow. Maybe this will help you figure something out in the meantime.

Erdin? E. Ka
12-12-2008, 08:28 PM
Hi malik,

That's a very good work. :hi: I very thank you to do this. :friends:

But, if we can complete all of that, thats gonna be really perfect... :p

Loves from Bursa... :*)