• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 31. Advanced VBA Programming > Creating Custom Forms in the VB Editor

Creating Custom Forms in the VB Editor

One of the most visible characteristics of the Windows family of operating systems is the dialog box. Every user quickly learns to use dialog boxes to perform everyday operations, such as opening and saving files, applying formatting, and selecting from the options of any program. Users like working with dialog boxes, because they're easy to use and pleasant in appearance. Applications that don't use dialog boxes often require users to answer a series of questions, one at a time, in a designated order. It might be difficult, or impossible, to go back and change an answer in a system designed in this fashion. Another scenario, which some spreadsheet designers might use, is to require users to make entries in cells scattered throughout one or more worksheets in a workbook. This process might be error prone, relying on the user to put data in the right place, and to know what the valid data values are.

Dialog boxes can relieve these problems in many applications. By gathering required data entries into a dialog box, you can make sure the user doesn't forget any entries, and that all data is entered in the correct location. You can make it easier for the users to select the right values by providing list boxes, check boxes, option buttons, and other controls that are easy and quick to use. The VBA code that goes with the dialog box can check to see if the entered data is valid, and then can update the spreadsheet with all the correct values. Dialog boxes can also allow the users to move about the dialog in any order, filling out the values as they like.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint