macro to select drop down

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChrisK - 23 Mar 2008 14:27 GMT

Can anyone suggest a macro for a check box to select a drop down box field

I have a check box labeled "insp" When it is checked upon exit it runs a
macro that hides a paragraph of text(which works fine) but I also need the
macro to pick dropdown4 and select its 5th choice on the list

Any ideas?
Thanks

Reply to this Message

Greg Maxey - 23 Mar 2008 14:51 GMT

You will need to run a macro on exit from "insp" :

Sub OEChkbox()
Select Case True
Case ActiveDocument.FormFields("insp").Result
ActiveDocument.FormFields("Dropdown4").DropDown.Value = 5
Case Else
ActiveDocument.FormFields("Dropdown4").DropDown.Value = 1 'or whatever
you want selected if the checkbox isn't checked.
End Select
End Sub

Signature

~~~~~~~~~~~~~~~~~~~~~~~~~~~
Greg Maxey - Word MVP

My web site http://gregmaxey.mvps.org
Word MVP web site http://word.mvps.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> Can anyone suggest a macro for a check box to select a drop down box
> field
[quoted text clipped - 6 lines]
> Any ideas?
> Thanks

Reply to this Message

ChrisK - 23 Mar 2008 15:13 GMT

Thanks thats perfect

> You will need to run a macro on exit from "insp" :
>
[quoted text clipped - 18 lines]
> > Any ideas?
> > Thanks

Reply to this Message

Rate this thread: