Word 2003 VBA to limit options in Inputbox to those in drop down
in [Word VBA]
|
Prev: welcome to windows7
Next: ComboBox text Limit
From: johnnykunst on 24 Apr 2010 07:36 That's great, but the problem is that for the first, it is only certain fields that are mandatory. For the second option, I couldn't use as I need to keep the drop downs as others will be editing the form from time to time & would not be able to use VBA. Sorry! --- frmsrcurl: http://msgroups.net/microsoft.public.word.vba.general/Word-2003-VBA-to-limit-options-in-Inputbox-to-those-in-drop-d
From: Graham Mayor on 24 Apr 2010 08:20
If the users still have the template then they could run the macro again. If you have more than one mandatory dropdown field, simply add another list box (or boxes) to the userform to collect the date for the field(s) in question and process them in the same way. It would only take a few more lines of code to read back any existing values from the fields as defaults for the re-displayed userform list boxes. e.g. With Me.ListBox1 .Clear .AddItem " " .AddItem "Fred" .AddItem "Bill" .AddItem "John" .AddItem "Susan" .ListIndex = 0 For i = 1 To .ListCount - 1 'skip the first item (0) If ActiveDocument.FormFields("Text1").Result = _ .list(i) Then .ListIndex = i End If Next i End With Furthermore, rather than edit the form from time to time, wouldn't it be better to create a new form? -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> "johnnykunst" <user(a)msgroups.net/> wrote in message news:eCNiVJ64KHA.4520(a)TK2MSFTNGP02.phx.gbl... > That's great, but the problem is that for the first, it is only certain > fields that are mandatory. > For the second option, I couldn't use as I need to keep the drop downs as > others will be editing the form from time to time & would not be able to > use VBA. > Sorry! > > --- > frmsrcurl: > http://msgroups.net/microsoft.public.word.vba.general/Word-2003-VBA-to-limit-options-in-Inputbox-to-those-in-drop-d |