I took the advice of a user and reworked my module so it only contains the prompts needed. This is just the start. But I noticed the variable s is not carrying over from the user form button clicks. When I call the macro it runs and fills everything out as it should but after click "yes" s=1 but is i restart this macro it is still saying s=0.
Also how can I loop this macro so when s"value" is changed the information is changed with out crashing excel?
Also how can I loop this macro so when s"value" is changed the information is changed with out crashing excel?
VBA Code:
Sub ProcessnaTEST()
Dim s As Integer
Dim Prompt As String
'DO"I tried to start the loop here"
Select Case s
Case Is = 0
Prompt = NightAuditP.ShowMsg("Are you ready to start the night audit file process?" & vbNewLine _
& "This is for the date of: " & Format(Date - 1, "mm-dd-yyyy"), NightAuditP.Previous.Visible = False, Button2Text:="Yes")
Case Is = 1
Prompt = NightAuditP.ShowMsg("Have you saved the" & vbNewLine & "Adjustment Log" & vbNewLine _
& " & " & vbNewLine & "Daily Cash Log?", , Button1Text = "Back", Button2Text = "Next")
Case Is = 2
Prompt = NightAuditP.ShowMsg("Please save all required documents to complete final packet." & vbNewLine _
& "Click OK once completed.", , Button1Text = "back", Button2Text = "next")
End Select
'loop"and end it here but it caused excel to freeze
End Sub