View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default UDF Prompts in XL2003

See:

http://groups.google.com/group/micro...6f0180ce2819d5
--
Gary''s Student - gsnu2007a


"michael.beckinsale" wrote:

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.