Key Points

  • You can create a custom dialog box by using a UserForm in Visual Basic. The controls on a UserForm are the same ActiveX controls you can insert on a worksheet.

  • When you create an application, designing the interface first helps you to identify the functionality you need.

  • When you create a dialog box, always make sure the tab order of the controls makes sense for users who like to use the keyboard.

  • Minimize the work your macro has to do by utilizing worksheet functionality such as custom views.

  • Have fun building applications with Visual Basic in Excel!

Microsoft Office Excel 2007 Visual Basic for Applications Step by Step
Microsoft Excel 2002 Visual Basic for Applications Step by Step (Step by Step (Microsoft))
ISBN: 0735613591
EAN: 2147483647
Year: 2004
Pages: 99
Authors: Reed Jacobsen © 2008-2017.
If you may any questions please contact us: