Dear Excel experts
I am using a user form to obtain a user input. I want to use this user input in other user forms as well as modules while running a series of macros. The problem is that once the user form, in which the user input is collected is closed, that particular data is not available for use in other user forms and modules. Whenever I open another user form, the same input has to be collected over and again. As I scanned through various Excel help forums I gathered that the data I collect through the first user form must be declared as 'Public' or 'Global' so that it is available all through the project. But I can't figure out how to declare a variable as global or public. Can someone please help me to solve this.

Thanks in advance
Saji