View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam Wilson Sam Wilson is offline
external usenet poster
 
Posts: 523
Default Create a help hint for a UDF


I did not know the Ctrl + Shift + A! Good tip...

"Jacob Skaria" wrote:

This is called the tooptip and there is no direct way to create the same for
UDF with Excel VBA...

PS: After typing the =functionname hitting Ctrl+Shift+A will give you the
argument names displayed in the worksheet...()

If this post helps click Yes
---------------
Jacob Skaria


"Mary" wrote:

How does one add a help message/hint to a user defined function? The funtion
is created in Visual Basic in an Excel file.