View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
MrShorty[_34_] MrShorty[_34_] is offline
external usenet poster
 
Posts: 1
Default Use VBA functions in a worksheet?


"Jim Thomlinson came the closest - create a user-defined function. But
then,
what magic incantations do I have to invoke to use it in a cell
formula?
Thanks."

If you put the code in a regular module in the desired worksheet, or in
an add-in if you want the function available to all/several worksheets,
you call the function like you would any other worksheet function
=mydateadd(arg1,arg2,arg3,arg4)


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=490940