View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
LEO@KCC LEO@KCC is offline
external usenet poster
 
Posts: 9
Default How to Debug User Defined Functions

You cannot enter into "break-mode" for sub or function procedures that
require mandatory arguments. The trick is to set a break point in the
function and call the function from another macro.
Leo
"Kieranz" wrote in message
ups.com...
Hi All,
I have written a user defined function but when i go to VBE and press
F8 to step thru the code it does not work. I have gone on many
websites but most seem to show you how to create, not after... like
debug. Any help or website referral appreciated. Thks.
Rgds
KZ