Consulting | Excel Examples

Data Validation

Keywords: Custom Dialog, Validation, Dialog Frame, Focus

Description: Demonstration of custom dialog box procedure that checks for error and prompts user for correct input.

Tip: A Visual Basic for Applications procedure and a custom dialog box can be used to prompt user to correct input errors. If you assign a Visual Basic for Applications procedure to the frame of the dialog box, you can set the focus of the dialog to highlight the first field with errors.

Guide to the Example: Click on the "Run Dialog" button on the sheet named "Notes". Enter incorrect values and test the operation of the Visual Basic for Applications procedures contained in the module "Module1"

Download File: Click Here
Tip: Click on the link above and choose "Save" to download the xls workbook to your hard drive or "Open" to open the workbook inside of your browser.

Last modified: May 21, 1996