You can't have named parameters in an Excel function.

What you can do is use the tooltip, or the function wizard.
Also, you could start typing the function and press CTRL+SHIFT+A.
eg. Type =VLOOKUP( then press those keys for the names of the arguments.


"mbobro" wrote in message
...
Hi,

There is a silly issue I got stuck for a while.

I used to write mostly procedures rather than functions. In order to
make them clear and easy to read when I called them I have formatted
the text like that:

procedure1 _
parameter1:=value1, _
parameter2:=value2, _
parameter3:=value3, etc.

now I wanted to do the same with UDF, but it doesn't work. The working
format is:

function1(value1, value2, value3, etc)

but it is harder to read afterwards.

It seems to me silly, but there is no direct example on MSDN or this
forum, so I decided to ask.


Thanks in advance,


Mbobro


---
Message posted from http://www.ExcelForum.com/