Word 2007

macropod · #1 09-14-2012, 04:54 PM

Well, that is rather different to what we set out with. While it is do-able, I think it both complicates input (the user will have to choose a 'type' before being able to select one of the options for that 'type') and is also liable to create difficulties for those who have to process the data later on as there is no necessary consistency in the order or location in which items might be recorded. Furthermore, if the user selects the wrong type, then goes back and changes it, the dropdown will then have entries available for both types. Obviously, additional code will be required to clear the dropdown every time a 'type' is selected, before any new items are added.

Before proceeding, I'd suggest a re-think. If you do decide to go ahead, you'll need to post a copy of the revised document that the code is meant to work with.

skusekd · #2 09-17-2012, 08:36 AM

Thank you again!

I see what you're saying about the organization of the form, without separate headings it would be a little chaotic. So, back to the simple more organized idea

Problem though, I'm getting this error:

"Complie error: Invalid or unqualified reference" referring to the .Value in the "if .value = 11 Then"

Here's the macro I pasted along with my (minor) changes:

Code:

Sub FreeText()
Dim StrNew As String
With ActiveDocument.FormFields("NAME").DropDown
  If .Value = 11 Then
  StrNew = Trim(InputBox("Input your text", "Free text input"))
  If StrNew = vbNullString Then Exit Sub
    .ListEntries(11).Delete
    .ListEntries.Add StrNew
    .Value = 11
  End If
End With
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word 2007 Cannot Drag and Drop	Rbooks	Word	7	02-05-2015 11:27 AM
word 2007 - space issue	dupefree	Word	1	06-27-2012 06:05 AM
Dependent drop down lists in Word 2007	benbenasc	Word VBA	0	08-24-2011 06:34 AM
Word 2007 Issue	dollsgen	Word	1	08-21-2010 09:48 PM
Converting issue 2003 word to 2007(new to 2007 office)	lbrown3	Word	0	01-30-2010 07:25 PM