Insert macro name in code on call statement.

Is there a way to list the macros (subs) that exist, sort of like F3 to list
named ranges, so when I do a call to another macro, it will pop up the name
so I dont' have to type it, thereby eliminating possible errors?
--
Marv Lusk
Boise Corporation

If you use a unique naming convention, like procMacroName, then by typing
proc and then hit Ctrl-spacebar you get a list of all procedures starting
with proc. I tend to name mine pXXFunction, where XX is a two letter acronym
for the module they are in, that way I can easily get them.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MarvInBoise" <MarvInBoise@discussions.microsoft.com> wrote in message
news:94177AB4-1633-4A44-82D6-E38717FBF85A@microsoft.com...
> Is there a way to list the macros (subs) that exist, sort of like F3 to
list
> named ranges, so when I do a call to another macro, it will pop up the
name
> so I dont' have to type it, thereby eliminating possible errors?
> --
> Marv Lusk
> Boise Corporation

Perfect! Thank you!!
--
Marv Lusk
Boise Corporation


"Bob Phillips" wrote:

> If you use a unique naming convention, like procMacroName, then by typing
> proc and then hit Ctrl-spacebar you get a list of all procedures starting
> with proc. I tend to name mine pXXFunction, where XX is a two letter acronym
> for the module they are in, that way I can easily get them.
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "MarvInBoise" <MarvInBoise@discussions.microsoft.com> wrote in message
> news:94177AB4-1633-4A44-82D6-E38717FBF85A@microsoft.com...
> > Is there a way to list the macros (subs) that exist, sort of like F3 to
> list
> > named ranges, so when I do a call to another macro, it will pop up the
> name
> > so I dont' have to type it, thereby eliminating possible errors?
> > --
> > Marv Lusk
> > Boise Corporation
>
>
>