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

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

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

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