Creating a Windows DLL with Visual Basic
Subject:   using this to create descriptions in Excel function wizard
Date:   2008-07-31 02:24:53
From:   smallweed
Thanks for this - I've used it to create a DLL of dummy functions to aliase in the fix (outlined at for creating descriptions for individual arguments of UDFs in Excel's function wizard.
Works great until I close and open my add-in and try again to enter a worksheet function by way of the wizard at which point Excel always crashes with an unhandled exception. I'm wondering if this is because there isn't an adequate "clean up" going on in DllMain. Can anyone give me some pointers as to how I could program this into the DllMain?