Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 09-17-2012, 08:14 PM
macropod's Avatar
macropod macropod is offline Word 2007 - Drop Box Issue Windows 7 64bit Word 2007 - Drop Box Issue Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,362
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

That may be because you don't have 11 entries - your previous examples only had 10.

FWIW, you can get around the need to keep count of how many entries there are by using:
Code:
Sub FreeText()
Dim StrNew As String, i As Long
With Selection.FormFields(1).DropDown
  i = .ListEntries.Count
  If .Value = i Then
    StrNew = Trim(InputBox("Input your text", "Data Entry", .ListEntries(i).Name))
    If StrNew = vbNullString Then Exit Sub
      .ListEntries(i).Delete
      .ListEntries.Add StrNew
      .Value = i
  End If
End With
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



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 - Drop Box Issue 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft