| 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) | |||
Hybrid Mode
