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

not with a UDF I'm afraid.

"Raja" <(E-Mail Removed)> wrote in message
news:936A1F7B-9FEF-4C5F-9B96-(E-Mail Removed)...
>
> 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
>
>
>

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" <(E-Mail Removed)> schrieb im Newsbeitrag
news:936A1F7B-9FEF-4C5F-9B96-(E-Mail Removed)...
>
> 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
>
>
>

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
>
>
>