Parsing Arguments Question

[skuzapo]

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.

[Gary''s Student]

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
>
>