Variables values don't carry over to other Userform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frankbelly - 26 Oct 2006 22:19 GMT

I am using two different userforms. One pops up and has a txtbox for the
user the enter information. The value of this txtbox is accessible on that
form only when I hide that form and show another, I can't access the txtbox
value from the first form. I need the value from the txtbox on the first
form to be accessible on both forms.

Any help is GREATLY appreciated.

Thanks,

Reply to this Message

Pat Garard - 26 Oct 2006 23:45 GMT

G'Day Frank,

Declare a Global string variable. Before hiding Form1, set the Global
variable equal to the txtBox value. Have the second userform access
the value global variable.

Signature

Regards,
Pat Garard
Melbourne, Australia
_______________________

>I am using two different userforms. One pops up and has a txtbox for the
> user the enter information. The value of this txtbox is accessible on that
[quoted text clipped - 5 lines]
>
> Thanks,

Reply to this Message

Frankbelly - 28 Oct 2006 09:08 GMT

Sorry for the late Reply. Thank you so much Pat. This worked Perfectly!

> G'Day Frank,
>
[quoted text clipped - 10 lines]
> >
> > Thanks,

Reply to this Message