| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to debig a UDF
Got it. Thanks.
-- DRK "MDW" wrote: Go to the Visual Basic window (alt+F11) and locate the UDF. Place a breakpoint at the first line of executable code (highlight anything on the row and press F9). Go back to a cell using the function, put your cursor in the formula bar, and hit Enter on your keyboard. This SHOULD begin execution of the macro, and the VB window will jump to your breakpoint. Then you can use F8 to page through line by line and discover the calculation error. -- Hmm...they have the Internet on COMPUTERS now! "DRK" wrote: I have a former coworker's spreadsheet. It has a UDF which is returning #Value. How do you debug this? I have Excel 2003 and I've tried the evaluate formula but it wals through the first argument and then goes to #value beyond that. How do you debug a UDF? -- DRK |
Threaded Mode
