ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   UDF Prompts in XL2003 (https://www.excelbanter.com/excel-programming/400751-udf-prompts-xl2003.html)

michael.beckinsale

UDF Prompts in XL2003
 
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

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.



michael.beckinsale

UDF Prompts in XL2003
 
On 7 Nov, 17:29, Gary''s Student
wrote:
See:

http://groups.google.com/group/micro...rogramming/bro...
--
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.- Hide quoted text -


- Show quoted text -


Hi Gary,

Thanks for the link.

Exactly what l needed.




All times are GMT +1. The time now is 02:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com