Help with UDFs in Excel 2010

[leonard522]

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

 

[Jim Cone]

HALT is an Excel 4 macro function that is used to stop the macro.
--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/ExtrasXL




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

 

[leonard522]

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"?

 

[leonard522]

I am a firm believer in the adage of not fixing something that is not
broken.  Whether converting it to VBA will "improve" it or not, is
something not easily answered.  It might be easier to maintain the
work, and update it if necessary to accomodate changes in the
underlying data.  Of course, VBA may not have an unlimited life span
either.- Hide quoted text -

- Show quoted text -

One more question...sorry! And thanks for all your help! I was able
to get my XLM Macro working in one worksheet in excel, but not
another. I think I need to save it in my Personal macro workbook, but
don't know how to do it with this type of macro. Once I do that,
should the UDF be available in all my workbooks on my machine?
Thanks!!
Jen