Microsoft Office Tutorials and References
In Depth Information
An Enhanced Data Form
Figure 15-27: Creating a light-box effect in Excel.
An Enhanced Data Form
The example in this section is probably one of the more complex UserForms that you’ll
encounter. I designed it as a replacement for Excel’s built-in Data Form, which is shown in Figure 15-28.
Displaying Excel’s Data Form is not easy in Excel 2010. This command isn’t part of
Excel’s user interface, so you need to add the command to the Ribbon or to the Quick
Access toolbar. To add it to the Quick Access toolbar, right-click the Quick Access
toolbar and choose Customize Quick Access Toolbar. Then, in the Excel Options dialog box,
add the Form command from the Commands Not in the Ribbon group. Then, the Form
command will appear on your Quick Access toolbar.
Like Excel’s Data Form, my Enhanced Data Form works with a list in a worksheet. But as you can
see in Figure 15-29, it has a dramatically different appearance and offers several advantages.
 
Search JabSto ::




Custom Search