passing Values from one user form to another
How to get the value of a text box from one userform to another userform. for me the value is always shown as null.
Thanks in advance
Re: passing Values from one user form to another
You can get the value with a statement like this: UserForm1.TextBox1.Text
The reason the value is always shown as null may be because the form containing the text box is a modal form and you're setting the textbox value at run-time. This means that the form containing the textbox will be closed when your trying to read the textbox value. You will have to use either modelss forms or properties of modal forms that are set at design-time.