UDF Prompts in XL2003

[michael.beckinsale]

Hi All,

With XL2003 built in functions you get prompts for the various
parameters / arguments as you type into the cell.

eg typing =Sumif( directly into a cell results in this prompt:

SUMIF(range, criteria,[sumrange])

Can this be achieved with UDF and if so how?

Regards

Michael B.

 

[Gary''s Student]

See:

http://groups.google.com/group/micr...=udf+screentips+group:*Excel#106f0180ce2819d5

 

[michael.beckinsale]

See:

http://groups.google.com/group/microsoft.public.excel.programming/bro...
--
Gary''s Student - gsnu2007a

Hi All,

With XL2003 built in functions you get prompts for the various
parameters / arguments as you type into the cell.

eg typing =Sumif( directly into a cell results in this prompt:

SUMIF(range, criteria,[sumrange])

Can this be achieved with UDF and if so how?

Michael B.- Hide quoted text -

- Show quoted text -

Hi Gary,

Thanks for the link.

Exactly what l needed.