View Single Post
 
Old 09-18-2014, 10:53 AM
gmaxey gmaxey is offline Windows 7 32bit Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,617
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

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
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote