Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a help hint for a UDF
How does one add a help message/hint to a user defined function? The funtion
is created in Visual Basic in an Excel file. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a help hint for a UDF
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a help hint for a UDF
Just to add a description to be viewed by the user in the function wizard you
can try the below.. --From VBEpress F2 Object Browser --From librariees select VBAprojectFrom classes select the module which contain the UDF and from members select the UDF --Right click the UDFpropertiesenter description which will be displayed in the function wizard. --More here http://www.jkp-ads.com/articles/RegisterUDF00.asp If this post helps click Yes --------------- Jacob Skaria "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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a macro to create excel line graph with coloured pointers anddata lables | Charts and Charting in Excel | |||
Excel'03 - non printing help/hint automated messages | Excel Discussion (Misc queries) | |||
How to create adress list so can mail merge and create labels? | Excel Discussion (Misc queries) | |||
Create dictionary of terms, create first time user site | New Users to Excel | |||
any hint for using excel to create a model? | Excel Discussion (Misc queries) |