![]() |
#1
|
|||
|
|||
![]()
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 Last edited by macropod; 09-07-2012 at 09:33 PM. Reason: Added code tags |
Thread Tools | |
Display Modes | |
|
![]() |
||||
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 |
![]() |
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 |
![]() |
leroytrolley | Excel | 4 | 08-22-2008 03:57 AM |