JKP Application Development Services.

                    Microsoft Office Application Development

Setting things up

Up • Introduction • How does it work? • Setting things up • Class Module • VBA code • Put to Use • Wrap Up
•  •

Search Zoeken

WWW
This site

Go to Ga Naar
Home
Up

Donate Donaties
Did you find something helpful on my site? Consider a donation!
Heeft u iets gevonden waar u wat aan had? Overweeg dan een donatie!

 

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 UDF's 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 it's 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.

<< >>

 

    Subscribe in a reader

powered by longhead.com

Use the contact page to issue questions or comments about this website.
Copyright © 2003-2007 JKP Application Development Services.