Problem: I would like to add a single sentence to a document if a certain drop down box is selected.
Apologies if this has been covered before, but I was unable to find anything in the forum.
I have a form with a drop down list, that, when selected, I would like to have it update a text field. I have been able to find the vba to create cascading drop downs through a series of case statements, but am unable to recreate something similar for a text box, rather than a combo box.
Can someone please assist with the code I've posted, below:
Sub FLSA_Status() If ActiveDocument.FormFields("DropDown1").DropDown.Value = 0 Then ActiveDocument.FormFields("Text2").DropDown.ListEntries.Clear Exit Sub End If Select Case ActiveDocument.FormFields("Dropdown1").Result Case "Exempt" With ActiveDocument.FormFields("Text2"). .Add "This position is exempt" End With End Select End Sub
Last edited by justinhampton81; 08-25-2011 at 02:16 PM.
You'd better add code tags before....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks