View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] leonard522@aol.com is offline
external usenet poster
 
Posts: 8
Default Help with UDFs in Excel 2010

On Jul 11, 2:50*pm, Ron Rosenfeld wrote:
On Sat, 10 Jul 2010 19:56:52 -0700 (PDT), "

wrote:
Hi ~
I am working on a project that is a worksheet containing a UDF. *It
seems that it wasn't made using VBA?! *Instead it is a worksheet with
the first line as the function name, and the next lines showing the
arguments, and then several lines doing the function. *It ends with
=HALT(). *Can someone point me in the right direction to understand
how to use this or modify it!? *When I search for help on this topic,
all seems to refer to UDFs or Macros created with VBA.


Thanks !!
Jen


These are macro sheets from Excel prior to Excel 97. *Look for HELP
for XLM Macros. *(Back then, MS used to distribute printed manuals,
which included documentation for this).


Thanks for the info! I will google the XLM Macros. As part of the
project, I am asked to help improve the functions if possible. Would
converting from an XLM Macro sheet to a VBA Macro have benefits,
besides that it is "current"?