List Menu Information : Menu « Application « VBA / Excel / Access / Word

VBA / Excel / Access / Word

1.	Access
2.	Application
3.	Data Type
4.	Data Type Functions
5.	Date Functions
6.	Excel
7.	File Path
8.	Forms
9.	Language Basics
10.	Math Functions
11.	Outlook
12.	PowerPoint
13.	String Functions
14.	Windows API
15.	Word
16.	XML

Java Source Code / Java Documentation

Java Open Source

Jar File Download

Photoshop Tutorials

Flash Tutorials

3ds-Max Tutorials

Illustrator Tutorials

C# / CSharp Tutorial

C# / CSharp Open Source

ASP.NET Tutorial

JavaScript DHTML

JavaScript Tutorial

JavaScript Reference

HTML CSS Reference

Python Tutorial

Python Open Source

SQL Server / T-SQL

SQL Server / T-SQL Tutorial

Oracle PL / SQL

Oracle PL/SQL Tutorial

VB.Net Tutorial

Flash / Flex / ActionScript

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

Microsoft Office Word 2007 Tutorial

VBA / Excel / Access / Word » Application » Menu

List Menu Information


 

Sub ListMenuInfo()

    On Error Resume Next

    For Each Menu In CommandBars(1).Controls

        For Each MenuItem In Menu.Controls

            For Each SubMenuItem In MenuItem.Controls

                Debug.Print Menu.Caption

                Debug.Print MenuItem.Caption

                Debug.Print SubMenuItem.Caption

            Next SubMenuItem

        Next MenuItem

    Next Menu

End Sub

Related examples in the same category

1.	Creating a Menu Bar
2.	Add a new menubar with toggle action
3.	Controling a CommandBarControl's Visibility
4.	Deletes a control tagged "MyMenu2"
5.	Create Submenus
6.	Adds button, combobox, text box and drop down to tools menu
7.	List ShortCut Menus
8.	Adding and deleting menus automatically
9.	Disabling or hiding menus
10.	Working with checked menu items
11.	Disabling a shortcut menu
12.	Enables the shortcut menu when the workbook is closed.
13.	Create a new menu bar that replaces the existing menu bar
14.	Adding a menu: Take 1
15.	Adding the Budgeting menu to Excel's main menu bar
16.	Determined the Id property of the Help menu by executing the following statement:
17.	Deleting a menu from a menu bar
18.	Adding selections and submenu items to the Budgeting menu
19.	Adding a selection to Excel's Tools menu
20.	Deleting a menu item from the Tools menu
21.	Adding a menu selection that features a shortcut key
22.	Adding menu items to shortcut menus
23.	Deleting menu items from shortcut menus
24.	removes the Hide menu item from two shortcut menus: the one that appears when you right-click a row header and the one that appears for a column header.
25.	Disabling shortcut menu items
26.	Disabling shortcut menus
27.	If you want to disable all shortcut menus, use the following procedure:
28.	Resetting shortcut menus: The Reset method restores a shortcut menu to its original condition.
29.	Creating an entirely new and separate shortcut menu
30.	Adding a new item to the Cell shortcut menu
31.	Create a popup menu

www.java2java.com | Contact Us

Copyright 2009 - 12 Demo Source and Support. All rights reserved.

All other trademarks are property of their respective owners.