Chapter 20. Building Dialog Boxes
Chapter 7 showed you how to display the built-in Excel dialog boxes
and how to use InputBox and the File dialogs to get information from the user. In this chapter, I show you how to create more complex data-entry forms, validate entries, and use the Visual Basic Forms Designer to create custom dialog boxes.
This chapter includes task-oriented reference information for Forms 2.0 user forms and controls: UserForm, CheckBox, ComboBox, CommandButton, Control, Font, Frame, Image, Label, ListBox, MultiPage, OptionButton, Page, RefEdit, ScrollBar, SpinButton, TabStrip, TextBox, ToggleButton. Those objects aren’t part of the Excel object model and so aren’t part of the Excel VBA Help. Instead, the help topics for those objects are found in C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\1033\FM20.CHM.
Tip
Code used in this chapter and additional samples are available in ch20.xls.
Get Programming Excel with VBA and .NET 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.
