Make your variable static. That is, DIM it outside of both your macros and
not inside any of them. The first macro can set the variable and the second
can see the value set by the first.
--
Gary''s Student


"skuzapo" wrote:


Hi all,

Please may someone advise how parsing arguments works (if that's what I
need to do)...

I have two user forms each with their own code. A button on the first
one opens the second form. Based on user selections in the first form
certain controls on the second are visible or not. The variable to
control this is in the code of the first form as it adds up a number of
things.

What I don't know how to do is - how do I tell the second form what the
value of that variable is?

Sorry - not a very challenging question for all the luminaries out
there!
Thanks in advance for your help.


--
skuzapo
------------------------------------------------------------------------
skuzapo's Profile: http://www.excelforum.com/member.php...o&userid=27430
View this thread: http://www.excelforum.com/showthread...hreadid=470036