Dialogs can make things easier for you and your end user. They can be used
to pre-validate entered information, apply business rules to it before
placing it onto a worksheet, and provide a way of making sure that all needed
information is entered for a given situation.
Lets say you use an Excel workbook to handle weekly payroll. You may need
to define an employee in a particular way, with some basic information:
Name, SSAN, Job Title, Pay Rate, etc.
You could put a button (or I like to use Text Boxes from the Drawing
toolbar) on the sheet that when clicked on would open up the dialog to enter
information about a new employee. Once the user enters the information and
clicks a "do it" button on that dialog form, you could then use VBA code to
check the information and validate it and place it properly on the worksheet.
I actually have something like this in use, and because the information on
the worksheets is so critical, all data entry and editing on all of the
worksheets in the workbook is done through dialogs that are provided from
pull-down choice of operations lists on the sheets.
In previous versions people would come along and enter numbers overwriting
formulas, enter invalid information for things like employee ID number, etc.
The use of dialogs has done away with those problems.
