Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I've got a startup Sub which has a msgbox with Y/N option. Thereafte it shows the Application.GetOpenFilename option and the file names ar stored to variables. Then I've got a userform that has comboboxes i it and after this private Sub is over, I need the variables that created in the startup Sub. These variables show Empty in the Watc section or it shows an Out of Subscript error. How can I keep these variables static so that I can use it later. I'v tried using Static, but it does not help Txs -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
Static y-axis | Charts and Charting in Excel | |||
Static Row | New Users to Excel | |||
Static Cenll | Excel Worksheet Functions | |||
Static variables | Excel Programming |