Macro to perform list functions and native Excel formulas

Logroastur

New member
Joined
May 8, 2011
Messages
1
Reaction score
0
Points
1
Website
www.pcfixlakeside.com
Good macro conducted a search for list of Excel functions and formulas, not if I could do something similar to list the names of the menu bar for example if we use

Code:
Sub NameCommandbars()
Dim cbr, ctl, xFil As Long
xFil = 2
For Each cbr In CommandBars
    Range("B" & xFil) = cbr.Name
    For Each ctl In cbr.Controls
        Range("C" & xFil) = ctl.Caption
        xFil = xFil + 1
    Next ctl
Next cbr
End Sub
get a list with the names of the menu bar

greetings and thanks in advance for your attention
 
Back
Top