Whats Next

Now that you've reached the end of this rather long chapter, you have the necessary skills for designing useful forms. Let's quickly summarize all that you've learned in this chapter. Built-in dialog boxes can be displayed from your own VBA procedures. For custom VBA applications that require user input, create a custom form. Make sure the user can move around the form in a logical order by setting the tab order. For the form to respond to user actions, write VBA procedures in a form module. Set the initial values of controls by using the Properties window or writing the UserForm_Initialize procedure. Make sure to include procedures to transfer form data to a worksheet. In the next chapter, you will get more hands-on experience with custom forms when you explore the subject of collections and custom objects.

0 0

Post a comment