Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
mac
excel.macintosh
frontpage.mac
inetexplorer.mac
internet.mail.mac
internet.news.mac
mac.entourage
mac.excel
mac.explorer
mac.mediaplayer
mac.messenger
mac.office
mac.otherproducts
mac.powerpoint
mac.rdc
mac.virtualpc
mac.word
macintosh.general
media.player.mac
messenger.mac
office.mac
office.mac.entourage
outlook.mac
outlookexpress.mac
win2000.macintosh
windowsnt.mac
word.macword2001
  
 
date: Mon, 23 Jun 2008 14:10:01 -0700,    group: microsoft.public.office.mac        back       


Form Fields and If Function in VB   
Microsoft Word - Vista but saving as a compatable 2003 dot template.

Two questions in one, need help.  Trying to create code in VB with an if 
statement.  A formfield (pulldown) has Yes and No in the list.  If No is 
selected, I want to execute a macro using the build-in macro execution within 
the formfield dialog box.  I used a macro to complete the action needed, but 
do not know the code for an "If" to execute it.  

Here is what is needed:
If "No" is selected, need to run the first section of the macro and if "Yes" 
is selected, need to run the second portion of the macro.  Assume an else 
statement will be used for the alternative. The bookmark for the formfield is 
Certification_Y_N.  Have been trying to use the following code:

activedocument.bookmarks.("Certification_Y_N") = "No" then

The remainder of the macro was built by using the macro builder in Word.  
All examples in references talk about msg boxes and dialog boxes, not my 
specific issue.

2nd Question, what does a checked formbox in Word return?  Thought it would 
be 1 or True, but that does not seem to be the case.  Wanted to use it in an 
embedded field with an If function.   Also does it have to be in quotes?
Thanks for the help. 


-- 
Calvin M.
date: Mon, 23 Jun 2008 14:10:01 -0700   author:   Calvin

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us