Microsoft Office Tutorials and References
In Depth Information
Entering Data Easily Using a Custom Dialog Box
Figure 69 – Easy Data Entry Dialog Box
This macro tool can be adapted to all correspondence needs.
The form gathers user input and inserts it into appropriate areas of the
document. After it finishes, the user can begin typing the body of the letter
immediately. The tool is set up to be reusable in a document: the macro always
picks up the bookmark contents that match the text box names, if the
bookmarks are present in the document.
View the Appendix to learn how to store this procedure
in a Standard module.
Option explicit¶
' * * * * *¶
Sub AutoNew()¶
End Sub¶
' * * * * *¶
Sub GetUserInput()¶
Search JabSto ::

Custom Search