Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variables and graphs | Excel Discussion (Misc queries) | |||
VBA passing variables through a function | Excel Discussion (Misc queries) | |||
Select Text Files from Combobox | Excel Discussion (Misc queries) |