Consulting | Excel Examples
Keywords: Database, Custom Dialog, Update, Scroll
Description: This is an example of a simple Visual Basic for Applications procedure that displays a custom dialog box and updates a data base.
Tip: You can create a custom dialog that updates a database with a Visual Basic for Applications procedure. The dialog can add new records, and edit or delete existing records. If you want to find a record, you can use a scroll bar to page through the database. The Module page in this example includes comments designed for novice users of Visual Basic for Applications.
Guide to the Example: Press "Show Dialog and Update Database" Button on "Demonstration" sheet. Examine controls on DBUpdate dialog sheet. Read comments and code in Module 1. Database is contained in range named "Database" on worksheet named "Datasheet".
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.