Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining two Subs | Excel Discussion (Misc queries) | |||
ending subs | Excel Programming | |||
Variable holding across multiple subs? | Excel Programming | |||
Private subs | Excel Programming | |||
Stringing Subs | Excel Programming |