Combo list -

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rexmann - 06 Jul 2005 16:03 GMT

Hi

I have a form in word with a drop down list and a number of options (taken
from the forms toolbar). I would
like people to be able to select an option or type their own option over the
top. At the moment they select other and then type into another text box. I
would like them to be able to override the options in the list.

Can anyone help me with the programming of a macro that does this (I guess
this is the only way to do this)

any help greatly appreciated

Rexmann

PS im running word 2002

Reply to this Message

Doug Robbins - 06 Jul 2005 19:33 GMT

You could do something like this (run on exit from the dropdown)

Dim NewItem As String
With ActiveDocument.FormFields("Dropdown1")
If .result = "Other" Then
NewItem = InputBox("Enter the item that you wish to use", "New Item")
.DropDown.ListEntries.Add NewItem
.result = NewItem
End If
End With

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi
>
[quoted text clipped - 14 lines]
>
> PS im running word 2002

Reply to this Message