Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / August 2006

Tip: Looking for answers? Try searching our database.

Form Field Entry & Exit Macro drop-down list

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Peter - 08 Aug 2006 15:00 GMT
Does anyone know where the list of macros is taken from for the entry and
exit macro for form fields? I am building a form and have added a textbox. I
want to execute a macro on exit. When I click on the drop-down list
associated with the exit macro on the Text Form Field Options dialog box, the
only macros I see are ones in my Normal.dot file. I want to select a macro I
have written in the form which has been saved as a .dot file.

Thanks!
Peter
Jean-Guy Marcil - 08 Aug 2006 15:28 GMT
Peter was telling us:
Peter nous racontait que :

> Does anyone know where the list of macros is taken from for the entry
> and exit macro for form fields? I am building a form and have added a
[quoted text clipped - 3 lines]
> file. I want to select a macro I have written in the form which has
> been saved as a .dot file.

You can only refer to macro that are in  currently active project (Loaded
template, or Normal.dot, the currently attached template and any template
that are loaded as global as listed under "Tools > Templates and
Add-ins...")

Also, make sure that the macro you want to use is not Private or requires
arguments or it will not be listed.

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Peter - 08 Aug 2006 15:47 GMT
My macros are in the currently active (and loaded) project. They are defined
as Public and have no arguments and yet they are not listed. The form is a
document template (.dot file) and is listed as a Global template in
Tools/Template and Addins. Do you have any other ideas?

> Peter was telling us:
> Peter nous racontait que :
[quoted text clipped - 14 lines]
> Also, make sure that the macro you want to use is not Private or requires
> arguments or it will not be listed.
Jean-Guy Marcil - 08 Aug 2006 16:22 GMT
Peter was telling us:
Peter nous racontait que :

> My macros are in the currently active (and loaded) project. They are
> defined as Public and have no arguments and yet they are not listed.
> The form is a document template (.dot file) and is listed as a Global
> template in Tools/Template and Addins. Do you have any other ideas?

Could there be conflicting names?
If two macros with the same name in different modules are present, I believe
neither will show up  the list.

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Peter - 08 Aug 2006 16:30 GMT
Thank you very much. For some unexplained reason, they are now showing up.
Word can be so buggy! It truly does not miss an opportunity to frustrate!
Thanks again!

> Peter was telling us:
> Peter nous racontait que :
[quoted text clipped - 7 lines]
> If two macros with the same name in different modules are present, I believe
> neither will show up  the list.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.