Hide/Unhide a Block of Text Based on Choice Selection

inquirer · #1 09-17-2014, 03:29 PM

I have a performance evaluation form as attached where employees are measured on their core competencies. They will be evaluated either with "Satisfactory" or "Improvement Needed" from the drop-down list. Here's what I'm struggling with. If "Improvement Needed" is selected, I want the "Improvement Plan" section to show up, otherwise that section would not show up. Any suggestions?

gmayor · #2 09-17-2014, 10:32 PM

It just needs a conditional field to evaluate the values of the two dropdowns that meet the criteria and display the text accordingly - see attached.
The field is updated when you tab out of either dropdown field.

inquirer · #3 09-18-2014, 08:41 AM

How do you set a conditional field?

gmaxey · #4 09-18-2014, 10:53 AM

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

gmayor · #5 09-18-2014, 09:06 PM

Quote:

Originally Posted by inquirer

How do you set a conditional field?

See the attachment I posted. Press ALT+F9 to display the field structure.

inquirer · #6 09-19-2014, 11:29 AM

Thank you for your responses. The Improvement Plan is a separate form and the folks know where to get it. So I just need that section to pop up when they are rated with "Improvement Needed". As you said, the conditional field works if you tab out of it. The problem is folks will not know that they have to do the tabbing. The macro would be a better option but I couldn't get it to work as I'm relatively new with this. I get the idea about making the macro to run on exit from the dropdown evaluation field, but the macro code itself requires some tweaking. I'm not sure how to code the macro to show/hide that block of text based on selection from the dropdown field. Any further clarification would be appreciated.

gmayor · #7 09-19-2014, 09:32 PM

A macro would merely have to update the fields to update the conditional field. e.g.

Code:

Sub UpdateMacro1()
ActiveDocument.Range.Fields.Update
End Sub

is all that is needed; however you cannot force a user to run macros, so you would be better instructing the users to tab through the fields as this doesn't require macros. You can add help text to the field or use an accompanying instruction.

inquirer · #8 09-22-2014, 04:41 PM

Thank you, I will look into that.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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