Scope issue Variable not defined 1

[vba317]

Recently I have moved as much code as I can into functions. The issue I am having is when I am calling the procedure from a form, whatever variables I am using come up as variable not defined. I add Dim statements in the form to remove trhe error message. Is there another way to declare a variable instead of having to dim it?

Tom

 

[Andrzejek]

Start a new one, please.

Have fun.

---- Andy

 

[strongm]

>So you cannot just Call it

Well ... you can. Perfectly legitimate. Sometimes you might call a function without caring about the return value, in which case Call is legitimate (and it might be worth knowing that under the covers a VBA procedure is implemented in exactly the same as a function, but the return value is discarded and never passed on to the VBA program; in other words, a VBA Procedure is just a semantic nicety ... )

Having said that, most of the return values here are actually being returned in the parameters, so converting to a procedure and using a UDT might make some sense ...