ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Exiting Multiple Subs? (https://www.excelbanter.com/excel-programming/330791-exiting-multiple-subs.html)

SS

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