UDF prompts
UDF prompts
(OP)
Is it really not possible to write those little prompts into a UDF? You know, those ones that tell you which bit of data goes in each argument's position?
We will design everything from now on using only S.I. units ... except for the pipe diameter. Unk. British engineer





RE: UDF prompts
(you see them when you use insert-function in the spreadsheet, and you can see them when you type function call in vba if you have the right settings).
I remember reading that there is a way to go a step farther, but variable names are always enough for me.
=====================================
(2B)+(2B)' ?
RE: UDF prompts
Nonetheless there is something to be said for doing the job "properly", especially if the functions will be used by someone other than the author.
The link below gives two alternatives for adding descriptions, one is easy but limited, and the other more trouble, but will do a better job.
ht
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: UDF prompts
Doug, that method looks like it will work, but I don't know if I want to go to that extreme. I might, if it was just one complex function, but I've got a number of them going in the same box and it might just be better to fall back to the insert box and leave it like that. Thanks very much for showing that workaround.
We will design everything from now on using only S.I. units ... except for the pipe diameter. Unk. British engineer
RE: UDF prompts
We will design everything from now on using only S.I. units ... except for the pipe diameter. Unk. British engineer
RE: UDF prompts