Global Variables using User Forms
Class modules (worksheet modules, userform module, thisworkbook module and
class modules) are private by default.
--
Regards,
Tom Ogilvy
Brad wrote in message
...
Neat. I thought all modules had the same scope.
-Brad
-----Original Message-----
If just using it within you project,
better in my opinion would be to declare it in a general
module
General Module: (Insert = Module in the VBE)
Public vTest as String
ThisWorkbook module
Sub The_Test()
vTest = "Can you see me?"
UserForm1.Show
End Sub
Userform Module
Private Sub UserForm_Initialize()
UserForm1.Caption = vTest
End Sub
Then you don't have to worry about qualifying it and all
elements of the
Project can see it (without qualifying it)
--
Regards,
Tom Ogilvy
"Brad" wrote in
message
...
This code belongs in the Workbook module:
Public vTest As String
Sub The_Test()
vTest = "Can you see me?"
UserForm1.Show
End Sub
This code belongs in the UserForm1 module:
Private Sub UserForm_Initialize()
UserForm1.Caption = ThisWorkbook.vTest
End Sub
You need to publicly declare it at the module level, and
in the form - qualify the module with the variable. So
to
access functions and variables from a UserForm,
explicitly
qualify with "ThisWorkbook" or whatever module it is.
HTH.
-Brad
-----Original Message-----
Is there a way to set global variables so I can use
them
in while I am coding in a user form. Right now I am
setting the variable up under the workbook and it works
in
any worksheet, however when I try to access that data
in
a
user form opened from the worksheet, it does not work.
Any Ideas?
Thanks,
Steve
.
.
|