Dialog Boxes and Custom Forms

Excel Dialog Boxes ■ File Open and File Save As Dialog Boxes ■ GetOpenFilename and GetSaveAsFilename Methods ■ Creating Forms ■ Tools for Creating User Forms ■ Placing Controls on a Form ■ Sample Application 1: Info Survey ■ Adding Buttons, Check Boxes, and Other Controls to a Form ■ Changing Control Names ■ Setting Other Control Properties ■ Preparing a Worksheet to Store Custom Form Data ■ Displaying a Custom Form ■ Setting the Tab Order ■ Understanding Form and Control Events ■ Writing VBA Procedures to Respond to Form and Control Events ■ Writing a Procedure to Initialize the Form ■ Writing a Procedure to Populate the List Box Control ■ Writing a Procedure to Control Option Buttons ■ Writing Procedures to Synchronize the Text Box with the Spin Button ■ Writing a Procedure that Closes the User Form ■ Transferring Form Data to the Worksheet ■ Using the Info Survey Application ■ Sample Application 2: Students and Exams ■ Using MultiPage and TabStrip Controls ■ Writing VBA Procedures for the Students and Exams Custom Form ■ Using the Students and Exams Custom Form ■ What's Next...

In Chapter 4 you learned how to use the built-in InputBox function to collect single items of data from the user during the execution of your VBA procedure. But what if your procedure requires more data at run time? The user may want to supply all the data at once or make appropriate selections from a list of items. If your procedure must collect data, you can:

■ Use the collection of the built-in dialog boxes

■ Create a custom form

This chapter teaches you how to display the built-in dialogs from your VBA procedures and design your own custom forms from scratch.

0 0


Post a comment