Passing variables

I have a question. Can this be done. Pass a couple of varibles back from a called sub routine?

The calling sub calls the called sub does which has code plus a couple of varibles needing to come back.

Scope: The called sub is a series of case statements with code and sets varibles which are needed back in the calling sub.

Thanks,

Ralph

Just like you can pass variables into a function in a cell (for instance a LOOKUP() formula has two or three parameters), you can pass a variable into a subroutine the same way.

Please Login or Register  to view this content.

This sub expects to see an value for the Var1 arrive with the call. So another sub could be looking for another variable "n" like so:

Please Login or Register  to view this content.

So that passes the value in cell A1 to the "testme" routine and gets a Boolean True/False answer back as the value of "n".

Is that the kind of thing you're talking about?


========
Alternately, you can declare a variable as PUBLIC so that the value in the variable survives from one sub to the next.

That doesn't compile, JB.

That doesn't compile, JB.

I thought it was just me. Phew! What a relief.

Originally Posted by shg

That doesn't compile, JB.

*groan**complain*...

That's what I get for posting "air code"... but the idea is still correct even if my syntax is off in the example...which probably is useless in the real need of the OP anyway.

If you post some actual examples of what you're trying to do, I can help construct that actually works... (shame)

I think in this case JB it's a case of routine 1 calling routine2 -> routine 2 generates some variables prior to completion -> upon completion routine 1 can now utilise those variables generated by routine2.

What is the nature of the 2nd routine ? Sounds to me like you should be using a Function - and calling the Function from Routine 1 ... eg

Please Login or Register  to view this content.

Bad example but you get the general gist.

If you do really need to use variables then you can (as already mentioned by JB) think about creating the variables as Public (see: http://www.ozgrid.com/VBA/variable-scope-lifetime.htm)

I have a different take on the OP's question.

You can pass variables ByRef or ByVal and have them updated and returned in the called routine.

Please Login or Register  to view this content.