Microsoft Office Tutorials and References
In Depth Information
Displaying a Data Form
Executing an old menu item directly
Another technique to display a built-in dialog box requires knowledge of the pre-Excel 2007
toolbars (officially known as CommandBar objects). Although Excel no longer uses
CommandBar objects, they’re still supported for compatibility.
The following statement, for example, is equivalent to selecting the Format➜Sheet➜Unhide
command in the Excel 2003 menu:
Application.CommandBars(“Worksheet Menu Bar”). _
Controls(“Format”).Controls(“Sheet”). _
Controls(“Unhide...”).Execute
This statement, when executed, displays the Unhide dialog box. Notice that the menu item
captions must match exactly (including the ellipsis after Unhide ).
Here’s another example. This statement displays the Format Cells dialog box:
Application.CommandBars(“Worksheet Menu Bar”). _
Controls(“Format”).Controls(“Cells...”).Execute
It’s probably not a good idea to rely on CommandBar objects because they may be removed
from a future version of Excel.
Displaying a Data Form
Many people use Excel to manage lists in which the information is arranged in rows. Excel offers
a simple way to work with this type of data through the use of a built-in data entry form that
Excel can create automatically. This data form works with either a normal range of data or a
range that has been designated as a table (by using the Insert Tables Table command). Figure
12-12 shows an example of a data form in use.
Making the data form accessible
For some reason, the command to access the data form isn’t in the Excel Ribbon. To access the
data form from Excel’s user interface, you must add it to your Quick Access toolbar or to the
Ribbon. Following are instructions to add this command to the Quick Access toolbar:
1.
Right-click the Quick Access toolbar and select Customize Quick Access Toolbar.
The Quick Access Toolbar panel of the Excel Options dialog box appears.
2.
In the Choose Commands From drop-down list, select Commands Not in the Ribbon.
 
Search JabSto ::




Custom Search