Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How add a value help parameter to User Defined Funtion
I want to provider the user a value help when filling formula paramter. for example, when you fill the "[RangeLookup]" parameter of VLOOKUP method, excel display to you an option to select TRUE - Approximate match FALSE - Excat match Is that possible? Regards, Raja |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How add a value help parameter to User Defined Funtion
not with a UDF I'm afraid.
"Raja" wrote in message ... I want to provider the user a value help when filling formula paramter. for example, when you fill the "[RangeLookup]" parameter of VLOOKUP method, excel display to you an option to select TRUE - Approximate match FALSE - Excat match Is that possible? Regards, Raja |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How add a value help parameter to User Defined Funtion
Hi there
Go to the data menu and choose something like validation (I don't know the excact name of the menu in English). Kind regards, Alex ------------------------------------ Excel-Spezialist www.excelspezialist.ch ------------------------------------ "Raja" schrieb im Newsbeitrag ... I want to provider the user a value help when filling formula paramter. for example, when you fill the "[RangeLookup]" parameter of VLOOKUP method, excel display to you an option to select TRUE - Approximate match FALSE - Excat match Is that possible? Regards, Raja |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How add a value help parameter to User Defined Funtion
Raja
Just to add to the comments...which might be of help. Pressing Ctrl+Shift+A after typing the first bracket gives you the argument names as in the UDF... =samplefunction( If this post helps click Yes --------------- Jacob Skaria "Raja" wrote: I want to provider the user a value help when filling formula paramter. for example, when you fill the "[RangeLookup]" parameter of VLOOKUP method, excel display to you an option to select TRUE - Approximate match FALSE - Excat match Is that possible? Regards, Raja |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Defined type as Sub parameter? | Excel Programming | |||
Nominated range not recognised in User Defined Funtion | Excel Programming | |||
extract parameter VALUE form a user-defined function.. | Excel Programming | |||
User defined functions - parameter descriptions | Excel Programming | |||
Using linked workbook as a parameter in a user defined function | Excel Programming |