I am currently experiencing a difficulty in Excel 2000. I am using user
> forms to get information from a user. The variables are set in one user
> from
> and then another userform is shown. The values are lost when the second
> user
> form is opened. The variables are declared as Public in the general
> section
> of the first user form.

p10rpc,

You can't declare global variables in a Userform.

Suggest that you have a startup module that sets the global variables then shows the Userform (i.e., Userform1.Show).

Must use the Public declaration rather than simply Dim for the variables to be recognized in both modules and Userforms.

CarlR

declaring a public variable in module should be fine..