| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert macro name in code on call statement.
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert macro name in code on call statement.
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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel code to call a macro when a certain value in a cell isselected. | Excel Worksheet Functions | |||
| how can I insert a macro into a boolean statement | Excel Worksheet Functions | |||
| Call recorded macro from VBA code | Excel Programming | |||
| How To Call VBA Code from Excel 4 Macro | Excel Programming | |||
| Can you call a macro as in an IF statement | Excel Programming | |||
Linear Mode
