Posted by Geoff on June 19, 2000 5:58 AM
I'm using Excel for a VBA program I'm writing and I'm having a variable scope problem. I will provide as much detail as possible about the problem. Okay, to start off I have several sheets in my workbook. On the starting sheet, a user has 3 choices they can make (3 different buttons they can click). When the user clicks a button, it opens a form with some options on it. When they are through choosing options and then click "Ok", I unload the form and activate a certain sheet in the workbook depending on what options they chose in the form. What I would like to know is when the form is unloaded, does the execution of the program actually stop? or is it still running? The reason I ask is because I have some global variables declared in a module whose values are not being "remembered" throughout the entire program. I hope this isn't too confusing. Thanks for any help.