Public Variable

Hi Mike,


> I am delclaring a variable in the declarations area of the a module. So
> when I show a form, I should be able assign a value to it, unload the form,
> and still have the value of the variable... right?
> --
> Thanks,
> Mike

Wrong!.

The variable's value won't be available after you unload the form.
You need to hide the form using the UserForm's Hide method. When you
are finished you can then unload it.

Cheers
TonyS.

If the Public variable is declared in a standard module, but set by a
procedure in a userform module, it persists if the userform is unloaded.

Standard Module:

Option Explicit
Public strWhatever As String

Sub ShowPubVar()
Msgbox strWhatever
End Sub


Userform Module (with just one commandbutton):

Sub CommandButton1_Click()
strWhatever = "Hello world."
Unload Me
End Sub

If you show the userform, click the commandbutton, it passes the string to
the Public variable, and unloads.

If you execute ShowPubVar afterwards, it displays the set value of the
variable. The userform does not have to Hide first.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/word-programming/200709/1

On Sep 25, 4:29 am, "fumei via OfficeKB.com" <u37563@uwe> wrote:
> If the Public variable is declared in a standard module, but set by a
> procedure in a userform module, it persists if the userform is unloaded.
>
> Standard Module:
>
> Option Explicit
> Public strWhatever As String
>
> Sub ShowPubVar()
> Msgbox strWhatever
> End Sub
>
> Userform Module (with just one commandbutton):
>
> Sub CommandButton1_Click()
> strWhatever = "Hello world."
> Unload Me
> End Sub
>
> If you show the userform, click the commandbutton, it passes the string to
> the Public variable, and unloads.
>
> If you execute ShowPubVar afterwards, it displays the set value of the
> variable. The userform does not have to Hide first.
>
> --
> Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/word-programming/200709/1

I stand corrected. I made the erroneous assumption that the Public
variable was declared in the Userform General declarations area not
the External module.



With a big grin and tongue firmly in cheek I say "my answer is correct
for the problem I define it to solve". Therefore of course my
comments do apply if the variable was declared in the Userform General
declarations area.

Cheers
TonyS.

Quite true.

It is all a matter of of scope, a much skipped over (IMO) area of
consideration. Simply put, a Public variable declared within a userform
module still only has scope within the life of the userform. When a userform
is unloaded all variables declared within it are gone. Keeping in mind, of
course, that Public arrays can not declared within an object (like a userform)
module.

So....declare it Public outside the userform module.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/word-programming/200709/1