How to put a tooltip on a user-defined function

by

Not a tooltip solution but an adequate workaround:

Start typing the UDF =MyUDF( then press CTRL + Shift + A and your function parameters will be displayed. So long as those parameters have meaningful names you at-least have a viable prompt

For example, this:

=MyUDF( + CTRL + Shift + A

Turns into this:

=MyUDF(sPath, sFileName)

More Related Contents:

  1. Save excel file multiple times with file names in another workbook.
  2. Read/Parse text file line by line in VBA
  3. How do I find the last column with data?
  4. Excel VBA: Answer gets “stuck”
  5. How to insert a picture into Excel at a specified cell position with VBA
  6. Save multiple sheets to .pdf
  7. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  8. filter out multiple criteria using excel vba
  9. Excel VBA autofilter all but three
  10. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  11. Parsing an ISO8601 date/time (including TimeZone) in Excel
  12. Getting the actual usedrange
  13. Delete a row in Excel VBA
  14. VBA: Convert Text to Number
  15. How can I run VBA code each time a cell gets its value changed by a formula?
  16. How to convert 32 bit VBA code into 64 bit VBA code
  17. Referencing Excel Userform Control Name Value From String (VBA)
  18. Refreshing all the pivot tables in my excel workbook with a macro
  19. Countif With Multiple OR Criteria
  20. Vlookup to copy color of a cell
  21. every possible combination of the contents of 2 columns in excel
  22. How to delete rows in Excel based on criteria using VBA?
  23. Macro to export MS Word tables to Excel sheets
  24. VBA WinHTTP to download file from password proteced https website
  25. Excel VBA – select multiple columns not in sequential order
  26. How to check whether certain sheets exist or not in Excel-VBA? [duplicate]
  27. Application.WorksheetFunction.Match method
  28. Excel – Using COUNTIF/COUNTIFS across multiple sheets/same column
  29. Delete all data rows from an Excel table (apart from the first)
  30. Excel telling me my blank cells aren’t blank

Leave a Comment