The quest for the Excel custom function tooltip

by

I’ve posted a proof-of-concept project to GitHub as the Excel-DNA IntelliSense project, implementing this.

Using the UI Automation classes to monitor the appropriate Excel user interface events, a form is displayed when appropriate.

The code is wrapped as an Excel-DNA add-in, and works on my Excel 2013 / Windows 8 machine. I’ve tested on one other configuration (64-bit Excel 2010 on Windows Server 2008) and had a serious problems.

For a C# function defined with the Excel-DNA attributes like this:

[ExcelFunction(Description = 
    "A useful test function that adds two numbers, and returns the sum.")]
public static double AddThem(
    [ExcelArgument(Name = "Augend", 
                   Description = "is the first number, to which will be added")] 
    double v1,
    [ExcelArgument(Name = "Addend", 
                   Description = "is the second number that will be added")]     
    double v2)
{
    return v1 + v2;
}

we get both the function description

Function Description

and when selecting the function, we get argument help

Argument Help

That looks nice, but it’s all still very flaky, only works on my machine and sometimes crashes Excel. It might be a start, though…

Update 9 May 2014:

I’ve made some progress figuring out how to make the argument help work under older Excel and Windows versions. However, it still needs quite a lot of work to get everything reliable. Anyone who would like to help with this should please contact me directly.

Update 18 June 2016:

Excel UDF IntelliSense support for both Excel-DNA add-ins and VBA functions is now being tested. See the Getting Started page on GitHub for instructions.

More Related Contents:

  1. Reading Datetime value From Excel sheet
  2. How to read an excel file in C# without using Microsoft.Office.Interop.Excel libraries
  3. Get instance of Excel application with C# by Handle
  4. Why does Microsoft.Office.Interop.Excel.Application.Quit() leave the background process running?
  5. How to open Outlook new mail window c#
  6. How to make correct date format when writing data to Excel
  7. Importing Excel into a DataTable Quickly
  8. How to save workbook without showing save dialog with Excel interop?
  9. Set data type like number, text and date in excel column using Microsoft.Office.Interop.Excel in c#
  10. C# – How to add an Excel Worksheet programmatically – Office XP / 2003
  11. Accessing an open Excel Workbook in C#
  12. How do I properly clean up Excel interop objects?
  13. How to export DataTable to Excel
  14. .NET console application as Windows service
  15. Reading excel file using OLEDB Data Provider
  16. How can I protect my .NET assemblies from decompilation?
  17. How to get the range of occupied cells in excel sheet
  18. Disposing of Microsoft.Office.Interop.Word.Application
  19. EPPlus number format
  20. Excel interop: _Worksheet or Worksheet?
  21. How to add data table with legend keys to a MS Chart in C#?
  22. Working with C# Anonymous Types
  23. Can you use optional parameters in code targeting .NET 3.5?
  24. How to write an image from byte[] into MS WORD using C# Windows application
  25. How can I programmatically create, read, write an excel without having office installed?
  26. Json.NET adding backslash while returning json serialized string
  27. Why appending AutoFilter corrupts my excel file in this example?
  28. Exporting to .xlsx using Microsoft.Office.Interop.Excel SaveAs Error
  29. Why is the binary output not equal when compiling again?
  30. How to construct WMI query

Leave a Comment