Visual basic code for Word 2003 template

KateAus · #1 09-05-2012, 01:03 AM

I am trying to help my daughter's preschool staff by creating a Word document template that will make an onerous administrative task quicker and easier.

I have discovered that to get the functionality we need, I have to create a userform with visual basic. Not being a developer, I have managed to get so far with it, but just can't work out how to get it to do the last step. Basically, I want it to:

1. as the user tabs into the form text field (bookmarked as Outcomes1), a list box (boxOutcomes1) pops up -- this much I can do

2. in the list box is a list of criteria that the staff member will select, using fmMultiSelectExtended -- this much I can do

3. after clicking the OK button on the pop up, the selected criteria will be inserted in the text field (Outcomes1) -- THIS I CAN NOT WORK OUT HOW TO DO!!

Below is the code I have found works up to the point where I'm stuck. Is there anyone out here in internet-land that can help me finish this little project?

Many, many thanks for any help. Even pointing me to another forum that can help would be appreciated.

Code:

Private Sub boxOutcomes1_Change()
ActiveDocument.FormFields("Outcomes1").Result = boxOutcomes1.Text
End Sub
 
Private Sub UserForm_Initialize()
boxOutcomes1.List = Array("a. Separates and settles well;", "g. Openly expresses feelings;", "h. Cooperates with others;", "i. Is learning to negotiate;", "j. Makes predicted transitions smoothly;", "k. Is open to new challenges and discoveries;", "l. Celebrates and shares their contributions and achievements;", "m. Identifies and writes own name;")
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word Visual Basic error - run time error 504	crazymorton	Word	11	01-13-2012 04:32 AM
Visual Basic Editor changes from 2003 to 2007	Rockitman31	Word VBA	4	09-21-2011 12:01 PM
Word Basic 2003 to Word Basic 2007 Incompatibility	Mark1110	Word VBA	1	12-29-2010 11:04 PM
Referencing Tables in Visual Basic Editor	DavidB	Word Tables	0	09-21-2009 04:01 PM
A little Visual Basic Help Please	leroytrolley	Excel	4	08-22-2008 03:57 AM