UserForm Variables

[jstevens]

I'm having a challenge passing to a variable a UserForm.TextBox1.value.

Example: oVar = UserForm.TextBox1.Value

I have declared the variable (oVar) as a public variable within the Userform but cannot use the variable in a module.

Your assistance would be appeciated.
John

[HansV]

You have to declare the variable in a standard module.

The code module of a userform (like that of a worksheet and like ThisWorkbook) is a class module. A public variable declared in a class module becomes a property of that class, it doesn't act as a "normal" public variable.

(You could keep the declaration in the userform module and use UserForm.MyVar to refer to it in other modules)

[jstevens]

Hans,

I did think of your suggestion but I'm UserFormed challenged today.

Would you kindly attach a sample file depicting both of your solutions.

Regards,
John

[HansV]

See the attached workbook (you have to enable macros).

First click the worksheet button to show the userform, then enter some text, and click the Hide UserForm button.

Then test the worksheet buttons below. The ones calling Test1 and Test3 should work, but the one calling Test2 should cause an error.

Finally, view the code in Module1 and in the module of UserForm1.

VariableDemo.xls

[jstevens]

Hans,

Thank you for the example file. I was unloading the Userform instead of hiding it which cleared out the TextBoxes.

Regards,
John

[rory]

Which is one reason you shouldn't really use the default instance of the class. If you declare a variable of the form class and use that, you would have had an error and realised that the form had been unloaded and therefore gone out of scope.