Functions in the Personal Macro Workbook

[Woodlander]

Hi guys,

I usually record subs in the PMW, but is it possible to have functions as well? They do not seem to work. I use Excel 2007.

Thanks

 

[Andrew Poulsom]

You can use them but you need to precede them with the name of the PMW. Putting them in an Add-In is the best option:

http://office.microsoft.com/en-us/excel-help/creating-custom-functions-HA001111701.aspx#BMavailable

 

[Woodlander]

Thanks Andrew

 

[Woodlander]

However, when I enter a regular Excel 2007 formula, I see a small box that reminds me of the parameters of the function, as well as a caption that describes the function being used.

With my formulae in an Add-In (as per Andrew's suggestion), how can I see which parameters need to be filled in?

 

[Andrew Poulsom]

It's not straightforward:

http://www.jkp-ads.com/articles/RegisterUDF00.asp

unless you have Excel 2010:

http://spreadsheetpage.com/index.php/tip/user-defined_function_argument_descriptions_in_excel_2010/