Asigning a macro to a formfield on exit

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 11 Jan 2006 21:57 GMT

I am creating a template for Word 97 upwards

I have created a dropdown formfield with code as follows, but I need to add
some code which assigns to that dropdown which runs a macro on exit which is
"occasion2". Please can someone assist me with some code:

Set myfield = _
ActiveDocument.FormFields.Add(Range:=Selection.Range, _
Type:=wdFieldFormDropDown)

With myfield.DropDown.ListEntries

.Add Name:="on NOT MORE THAN... "
.Add Name:="on an UNLIMITED number of occasions."

End With

Signature

Mark

Reply to this Message

Doug Robbins - Word MVP - 12 Jan 2006 05:19 GMT

With myfield.DropDown
.ListEntries.Add Name:="on NOT MORE THAN... "
.ListEntries.Add Name:="on an UNLIMITED number of occasions."
.ExitMacro = "occasion2"
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

>I am creating a template for Word 97 upwards
>
[quoted text clipped - 14 lines]
>
> End With

Reply to this Message