View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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.