Results 1 to 2 of 2

Thread: Macro to perform list functions and native Excel formulas

  1. #1

    Macro to perform list functions and native Excel formulas



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    323
    Articles
    0
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion

Posting Permissions

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