Sharing variables

[Rishad Talyarkhan]

I am developing an application using VBA with Excel as the
base, and have written several procedures using Global
variables which are shared between them.
I now want to provide a user interface using the forms
provided by VBA and want to share the variables. Defining
them as the same global variables by specifying them as
Public in the declarations area for the form does not seem
to work - they just have empty values. How do I share
these variables ??

 

[jaf]

userform1.variablename

 

[Rishad Talyarkhan]

Found problem - was defining the variables as Global in
both the module and the forms.