To achieve this result, we will use a UserForm and a class module, and assign any control dynamically created in the userform to the class module. Finally the aim of this tutorial is also to obtain a ...

To add code, double-click the UserForm to open its module and enter the procedures in Listing A. (Don’t try to copy and paste from this web page because the VBE will object to some web characters.

Userforms are a great way to solicit input. For instance, you can map a few bookmarks via a bit of VBA code, and a quick click can generate the address elements for a letter. By following these 10 ...