Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find new UDF to edit
I created my first function and it works great but now I need to edit
it to make some additions and improvements. But how do I find the code? When I select view macros the function does not appear in the list. I think this function was put in a general module but I sure can't locate it. The fucntion is callable and working from other macros so I know it's out there somewhere. Thanks John Keith |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find new UDF to edit
Open the workbook with the macro.
Hit alt-f11 to get to the VBE where macros live. Hit ctrl-r to see the project explorer (like windows explorer) Find the module you put the code in and you'll be able to edit the code. John Keith wrote: I created my first function and it works great but now I need to edit it to make some additions and improvements. But how do I find the code? When I select view macros the function does not appear in the list. I think this function was put in a general module but I sure can't locate it. The fucntion is callable and working from other macros so I know it's out there somewhere. Thanks John Keith -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find new UDF to edit
On Wed, 07 Oct 2009 20:20:47 -0500, Dave Peterson
wrote: Open the workbook with the macro. Hit alt-f11 to get to the VBE where macros live. Hit ctrl-r to see the project explorer (like windows explorer) Find the module you put the code in and you'll be able to edit the code. Thanks Dave, I'm still learning! John Keith |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find new UDF to edit
In ToolsMacroMacros you can type in the name of your UDF and then "Edit"
Gord Dibben MS Excel MVP On Wed, 07 Oct 2009 19:03:12 -0600, John Keith wrote: I created my first function and it works great but now I need to edit it to make some additions and improvements. But how do I find the code? When I select view macros the function does not appear in the list. I think this function was put in a general module but I sure can't locate it. The fucntion is callable and working from other macros so I know it's out there somewhere. Thanks John Keith |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find new UDF to edit
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Find under edit | Excel Discussion (Misc queries) | |||
The edit - find command | Excel Worksheet Functions | |||
Edit Find | Excel Programming | |||
Edit + Find | Excel Discussion (Misc queries) | |||
Edit/Find | Excel Programming |