View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron Bishop[_2_] Ron Bishop[_2_] is offline
external usenet poster
 
Posts: 1
Default User Defined Functions

Is there any way to trap the error of passing the wrong
number of arguments to a user defined function? Built-in
functions trap this error and present the user with an
error dialog. My user defined function simply returns
#VALUE! with no error message. The function is not even
being executed because a STOP as the first line of code
does not drop me into the VBA editor.

I know I could use the OPTIONAL or PARAMARRAY keywords but
I was hoping there might be a cleaner solution.

Thanks