How to define a variable in one UDF that will be available in a sub-UDF?

[JenniferMurphy]

Is there a way for me to declare a variable in a UDF so that it will be available to any UDF that it calls?

I tried

Public varname as double
Global varname as double

but they both got error messages.

A search turned up several webpages about global variables, but they all seem to indicate that I need to define the variables outside of the main UDF and that they then continue to exists as long as that workbook is open. I don't want that.

I just want the variables to be available to the main UDF and any that it calls and then go away when the main UDF exits.

Can that be done?

Thanks

 

[RoryA]

You can set Data Validation rules on your input cells.

 

[JenniferMurphy]

You can set Data Validation rules on your input cells.

That's a great suggestion. It might solve at least half of the validation problems. I'll look into it. I've never used it. Do you know of a good tutorial?

 

[JenniferMurphy]

There is a pretty good introductory tutorial on data validation here:

http://www.foundationupdates.com/webinars/2011/docs/10282011dataval.pdf

It's downloadable as a PDF.