tqm1
05-28-2007, 02:47 AM
Ref: http://www.excelforum.com/showthread.php?t=601456
Dear Experts
I assigned a Public Variable "code" on General Declaration of sheet1 as
public code as long
There is a command button, on Userform, with following codes
code = Application.InputBox("Enter value for code")
Unload Me
I write 100 into Inputbox.
When I recal the value of variable code, it shows empty instead of 100.
Why userform inputbox value does not come into variable CODE?
What is wrong?
I want to create some variable, that should be recal anywhere in
workbook or Userform.
So where I should assign variable and what type?
Please help
Dear Experts
I assigned a Public Variable "code" on General Declaration of sheet1 as
public code as long
There is a command button, on Userform, with following codes
code = Application.InputBox("Enter value for code")
Unload Me
I write 100 into Inputbox.
When I recal the value of variable code, it shows empty instead of 100.
Why userform inputbox value does not come into variable CODE?
What is wrong?
I want to create some variable, that should be recal anywhere in
workbook or Userform.
So where I should assign variable and what type?
Please help