Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Step thru a function procedure?
Can I step thru a function procedure..its long and hard to figure out..I'd
like to go thru it slowly to track the variables etc...like I can with a regular macro subroutine thanks for any assistance Craig |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Step thru a function procedure?
You can step through functions just like regular code. Set a break point at
the first line and run your code. if you are using a UDF from a worksheet you have to force a change of data in the wroksheet before the function will start. I nomally click on the cell and then go the the F(x) box at top of worksheet . then click on the end of the line in the F(x) box and press Return on the keybord. this wqy I don't have to change the data in the cell. You can also change data in the cell and that will force the function to be execute. You also have to be in the auutomatic calculation mode, otherwise, you also have to press F9 to have excel recalculate the worksheet and call the VBA funnctions. "Craig" wrote: Can I step thru a function procedure..its long and hard to figure out..I'd like to go thru it slowly to track the variables etc...like I can with a regular macro subroutine thanks for any assistance Craig |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Drop Down List with Step by Step Instructions for 2007 | Excel Worksheet Functions | |||
STEP MULTIPLY FUNCTION | Excel Worksheet Functions | |||
Is there a step by step procedure on macros? | Excel Discussion (Misc queries) | |||
Step 1: EOMONTH Function | Excel Programming | |||
What is the step-by-step procedure for making a data list? | Excel Discussion (Misc queries) |