Global Variable

[vivekchha]

I have created an application which is used for processing data for many years. At the start up of the application, I ask the user to select a year from a userform combobox. I want this value to be treated as global string variable. I defined it in the following manner

Please Login or Register  to view this content.

Then in a different module I was expecting that I would get the value of glbYr as received from this module. But I am getting null value.
Please suggest..

Sincerely
Vivekchha

[Kaper]

1) where is the above code placed ? It's wise (if not required?) to declare public variables in standard module.
2) is really combobox1 value one of the expected values (does msgbox show?) if not (msgbox shows) you do not have the option to re-assign proper value - just do all activation-related tasks and close form

[MarvinP]

Hi Vivekchha

The topic of Scope of a variable is covered very well in:
http://www.cpearson.com/excel/Scope.aspx

I think Kaper is correct to ask where you declared the global variable.

[vivekchha]

Thanks. I got the mistake. The above codes are in a form module and not in standard module.

Regards.

Vivekchha

[Norie]

Put the declaration for the global variable in a standard module, the rest of the code should stay in the userform module.