Hi
I'm a fresher to VBA scripting. I'm trying to assign a value to a global
variable defined in Userform' General Declaration and then using that value
in my module.

tried my way but values are blank when my Userform ends.

any suggestion would be a gr8 help. Calling all life savers..."HELP".

I think the easiest thing to do is to move the declaration to a general module.

Public MyVar as WhatEver



Anoop wrote:

Hi
I'm a fresher to VBA scripting. I'm trying to assign a value to a global
variable defined in Userform' General Declaration and then using that value
in my module.

tried my way but values are blank when my Userform ends.

any suggestion would be a gr8 help. Calling all life savers..."HELP".

--

Dave Peterson

Set it as a property of that form.

In the form add

Public Property Get MyVar As String
myVar = your_variable_name
End Property

and in the module where you show the form, retrieve the property afterwards


With Userform1

.Show
module_variable = .MyVar
End With

--
__________________________________
HTH

Bob

"Anoop" wrote in message
...
Hi
I'm a fresher to VBA scripting. I'm trying to assign a value to a global
variable defined in Userform' General Declaration and then using that
value
in my module.

tried my way but values are blank when my Userform ends.

any suggestion would be a gr8 help. Calling all life savers..."HELP".