How add a value help parameter to User Defined Funtion

R

Raja

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
 
G

Guest

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
VB.NET: How to declare a parameter in a worksheet-function 2
vlookup not working with defined name 3
Nested If Function to be converted into a user-defined customfunction 1
Pass named range to user defined function returns #value! 6
Remove a criteria from countif based on user selection 5
Creating a UDF to search a cell's formula 8
Copy a R1C1 formula to a user defined range results #NAME? error 2

Top