![]() |
Exiting Multiple Subs?
My program will run and call Step 1 (below)
Sub Step1() Call GetMasterList Call GetUnschedMaster €¦€¦€¦ This will then call the sub €śGetMasterList€ť Sub GetMasterList() Dim FileName As String FileName = "" Response = MsgBox("Locate Master Work Order List For This Week.", vbOKOnly, "Master Work Order List") FileToOpen = Application _ .GetOpenFilename("Excel Files (*.xls), *.xls") If FileToOpen = False Then Call Cleanup_Toolbars frmRunStyle.Show Exit Sub End If €¦€¦€¦ If the following portion of the above code is executed: If FileToOpen = False Then Call Cleanup_Toolbars frmRunStyle.Show Exit Sub End If Then the program will do some functions and eventually return to a start point. If the user then goes through the steps and gets to sub Step1 again, it will immediately jump to Call GetUnschedMaster How do I get it to rerun the Call GetMasterList???? Thanks ! SS |
All times are GMT +1. The time now is 02:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com