IF/THEN statements

A

aleeherself

I am writing a word purchase order with drop-down lists for the description
of each item. I have written a macro with an IF/THEN statement to print the
answer as blank if "None" is chosed in the drop-down list, and have chosen
the name of this Macro to run at the exit of the drop-down list. However, it
does not work. This is what I wrote, where have I messed up?

Sub DescriptionDropDown()
'
' DescriptionDropDown Macro
' Macro created 7/18/2006 by Audrey Lee
'
' IF BookmarkDescription$ = "None" THEN print ""

End Sub

Thanks for your help!

Audrey
 
J

Jezebel

First, you've commented out the only line in the macro that could actually
do anything.

Second, (assuming your question relates to the IF line) where does
BookmarkDescription$ come from? If you're trying to retrieve the dropdown
value, you need something like

activedocument.FormFields("FieldName").DropDown.Value

where "FieldName" is the name assigned to the dropdown.

Third, what are you hoping the 'print "" ' will do? Print where?
 

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