Userform and variables
 

Hi,

I have a userform: their are input boxes and the user inputs values. I am
writing code to read the values and then perform more calculations. The code
is in the modules and the variables that are input into the userform are in
the userform. So for example in the userform:

Private Sub TextBox2_Change()
Y = TextBox2.Value
End Sub

Then in the module I use Y for some calculations. Problem = I tried
declaring Y as a public variable but it loses its value when it is called in
the module.
Does anyone know how to get around this problem

Thanks for your help.

Userform and variables
 

Declare it as a Public variable within the module, not the userform.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Jeff" wrote in message
...
Hi,

I have a userform: their are input boxes and the user inputs values. I
am
writing code to read the values and then perform more calculations. The
code
is in the modules and the variables that are input into the userform are
in
the userform. So for example in the userform:

Private Sub TextBox2_Change()
Y = TextBox2.Value
End Sub

Then in the module I use Y for some calculations. Problem = I tried
declaring Y as a public variable but it loses its value when it is called
in
the module.
Does anyone know how to get around this problem

Thanks for your help.