Designing the User Interface
After you have completed your template design, it's time to begin creating your VBA code. As you can see, it is common to invest quite a bit of time into the template design, before even writing the first line of code.
The Visual Basic Editor (VBE) provides form design tools, which you can use to create custom dialog boxes. These dialog boxes have several advantages over requiring the user to enter text directly into a document:
Your VBA code can enter the input text in the correct location, or even at multiple locations throughout a document.
You can make data entry easy for the user, by adding list boxes, check boxes, option buttons, and other controls to the forms.
You can validate the data entry, making sure that ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access