How add a value help parameter to User Defined Funtion

  • Thread starter Thread starter Raja
  • Start date Start date
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
 
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
 
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

Programmatically identify a particular formula (VLOOKUP) in a cell 0
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Nested If Function to be converted into a user-defined customfunction 1
vlookup not working with defined name 3
VB.NET: How to declare a parameter in a worksheet-function 2
Pass named range to user defined function returns #value! 6
Compile Error:Variable not defined 4
user-defined data type capabilities 2

Back
Top