![]() |
|
|
|
#1
|
|||
|
|||
|
How do you set a conditional field?
|
|
#2
|
|||
|
|||
|
What improvement plan? There is no improvement plan in the document you attached.
Set a macro similar to the following to run on exit from your dropdown evaluation fields: HTML Code:
Sub Evaluate()
Dim oFld As Word.FormField
If Selection.FormFields.Count = 1 Then
Set oFld = ActiveDocument.FormFields(Selection.FormFields(1).Name)
ElseIf Selection.FormFields.Count = 0 And Selection.Bookmarks.Count > 0 Then
Set oFld = ActiveDocument.FormFields(Selection.Bookmarks(Selection.Bookmarks.Count).Name)
End If
Select Case oFld.Name
Case "Dropdown1"
If oFld.Result = "Improvement Needed" Then
MsgBox "Show plan 1"
Else
MsgBox "Hide plan 2"
End If
Case "Dropdown2"
If oFld.Result = "Improvement Needed (Below Satisfactory) (I)" Then
MsgBox "Show plan 2"
Else
MsgBox "Hide plan 2"
End If
End Select
End Sub
|
|
#3
|
||||
|
||||
|
See the attachment I posted. Press ALT+F9 to display the field structure.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Adding text to after a bookmark based on drop down menu choice
|
ksigcajun | Word VBA | 6 | 06-10-2014 09:39 AM |
| block selection in dropdown list | Intruder | Excel | 2 | 01-10-2013 10:20 AM |
| Hide/Unhide pictures | maloneb | PowerPoint | 1 | 01-18-2012 03:34 PM |
| Macro to populate a text form field based on dropdown selection | koloa | Word | 0 | 10-20-2011 11:52 AM |
Unhide and Re-hide in Excel 2003
|
thorgal67 | Excel | 1 | 07-16-2009 07:06 AM |