Ease of Use

Intermediate

Version tested with

2000 

Submitted by:

mdmackillop

Description:

Contains a file full of all the different types of controls that can be used to create a userform, and populate a document from the data entered. 

Discussion:

Opening the NewForm document hides the Word application and displays the Userform on the screen. After data is entered, the document can be previewed and/or printed. Data can be stored within the form or obtained from an Excel spreadsheet. Can be used with simple or complex documents to assist with data entry. Consider the options of a simple userform all the way to some type of entry where the data doesn't require storage (in which case, you'd use a database instead). If you need specific help with the controls and can't find anything in the knowledgebase here, just ask at the forum. 

How to use:

1. Download the zip file below.
2. Place Data.xls into a folder called C:\Atest.
3. Copy the NewForm document to a convenient location.

Test the code:

1. Open the document and use some of the controls as you would any form.

Sample File:

Data.zip 31.94KB 

Approved by mdmackillop