O'Reilly logo

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Second Edition by John Green, Stephen Bullen, Dennis Wallentin, Rob Bovey

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 13. UserForm Design and Best Practices

Dialog boxes of various kinds are a fundamental part of most Excel application user interfaces, ranging from message boxes to complex data entry forms. This chapter explains how to get the most out of custom dialog boxes built with VBA UserForms.

Principles

When we design and code UserForms we strive to adhere to a small set of basic principles whenever possible, as explained in the following sections. By following these principles you create UserForms that are easy to use, code, and maintain. While some of these principles may seem a little artificial at first, our experience has shown that sticking to them provides long-term rewards.

Keep It Simple

A UserForm should not require a help file to explain ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required