creating custom Excel functions

  • Thread starter Thread starter Homer Simpson
  • Start date Start date
H

Homer Simpson

Hi,

With the VS2005 for Office tools, is it possible to create custom functions
with tooltips? This has been a limitation of VBA and I'm wondering if I
can/will be able to do this.

Thanks,
Scott
 
Scott,

What do you mean by custom functions with tooltips? Do you mean in
Excel? Or do you mean functions that are exposed in the office environment
which you can get intellisense info for?

If you mean the latter, then I don't think it will work, since there is
no way to attribute your function with the Helpstring attribute in VS.NET
which the COM interop layer is going to pick up (this is what VBA in Office
is going to use for the description, I believe).

Hope this helps.
 
Back
Top