WORD MACRO

M

Matthew Andrews

I am having lots of problems with what should be a simple
macro. I am creating a form in word. What I want to happen
is that when the user selects a certain option from the
dropdown, it will execute another macro. however my code
doesnt seem to do that at all.

here is my code

Sub dropdown()
'
' dropdown Macro
' Macro created 9/12/2003 by matt
'
If dropdown1.Value = "Not Accepted" Then
comment
End If

End Sub
Sub comment()
'
' comment Macro
' Macro recorded 9/12/2003 by matt
'
Selection.comments.Add Range:=Selection.Range
End Sub

Can anyone help me so this executes when the dorp down
item is selected
 
D

Doug Robbins - Word MVP

Hi Matthew,

The correct syntax is

If ActiveDocument.FormFields("Dropdown1").Result = "Not Accepted" Then
Call Comment
End If

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top