Forms

C

caring4211

I'm still having trouble with the following. I did get one response that
said that in order for the Macro to show it "it must be a Public Sub with no
parms." I'm not sure what that means. Can someone help?


It seems that my FormField Option box is pointing to the wrong place. The
exit drop down box gives me Project.NewMacros or Normal.NewMacros as my two
choices rather than the macro that I've named and attached to my file.

See below string also:
I opened up my document which is called New Director. I then opened VBA
editor. I found "Project (New Director)" and opened it. It had three
additional plus signes under it. One is called Microsoft Word Objects, one
is Modules and one is References. Under Microsoft Word Objects it has the
word icon with "ThisDocument" Under Modules it has New Macros. When I
double click on it, it comes up with the name of the macro that I created for
this document. This is the only macro that I created for this document.
However when I then go to the space where the macro is to run on my document
and click the FormField Option box, it shows three macros available but none
of them are named the name I gave my macro.

Lynda


Did this post answer the question?
 
W

Word Heretic

G'day "caring4211" <[email protected]>,

Public Sub MyRoutine()
End Sub

now, if you do

Public Sub MyRoutine(SomeParameter as Whatever)
End Sub

it wont show up, nor will

Private Sub MyRoutine()
End Sub

or

Public Function MyRoutine()
End Function

It also wont show up if it is a class module, so if you are using
objects you need to access them from a 'wrapper' routine, a simplified
eg, in a std code module:

Public Sub UseMyObjectToDoACertainThing()
MyObject.Do ACertainThing
End Sub


Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


caring4211 reckoned:
 

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