JKP Application Development Services.

                    Microsoft Office Application Development

Register UDFs

Up • Defined Names • Corrupt Files • Create Addins • Startup Problems • Chart an Equation • Show Picture • Round2Digits • Control Events • Custom Find • FormulaWrapper • Disable Events • Workbook Open Bug • WebQuery • Register UDFs • Undo With Excel VBA • Select a range (VBA) • Transpose Table • Docking VBE Windows • Excel 2007 Tables • Excel 2007 Tables (VBA) • Update An Addin • Addin Installation • Object Lister • Excel 2007 FileFormat • Catch Paste
• 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
Introduction
How does it work?
Setting things up
Class Module
VBA code
Put to Use
Wrap 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

Warning. This technique uses a number of tricks that are officially unsupported. Use at your own risk. As far as I know however, this version does work reliably.

This article describes a method to register one's UDF with Excel so it shows up in a category of your choice, with argument descriptions as well:


Custom category created by technique described in the article


Argument descriptions created by technique described in the article

Click here to download the sample file.

Content:

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

    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.