Summing Up

Despite the myriad screens and dialog boxes provided by the Office applications, sometimes you need something else. User Forms provide the developer with the ability to create completely customized forms and dialog boxes. Not only can a User Form present a visual interface to the user, but it can also contain code that responds to the user's actions, processes data, and interacts with other parts of the application. Because User Forms are created as a type of object, they also have the many advantages of the object-oriented approach to programming.

Get Office® XP Development with VBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.