Most Valuable Professional


View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

Trainings

Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

What has changed?

PerfectXL Compare, for Spreadsheet Comparison
This Excel compare tool is fast, reliable, and easy to use. Compare two Excel files now and see for yourself!
Home > English site > Articles > Register UDFs > Setting things up

Registering a User Defined Function with Excel

Setting Things Up

Putting this method to use is fairly simple if one uses the workbook which can be downloaded here.

The workbook uses a table on sheet FunctionList, which all details of all UDFs can be entered:


Screenshot of worksheet table to set function details for the registration

Row 7 of this table is prefilled with function names of User32.dll which seem to be rarely used. Of course you can use any other dll here, with its accompanying functions.

Note that the worksheet has been protected (no password was set) to avoid accidental changes to fixed information and that rows 28-65536 are hidden.

The rest of the work is done using some XL4 macro code and some VBA code, as described on the next pages.