how to carry variable to another module

[Jake975]

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?

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

 

[Jake975]

I figured out the s reference. I had to reference the whole name like this:
s = VBAProject.NightAuditP.s
I still need help with the loop part though
Please and thanks for your time

 

[richh]

You can pass to the sub by reference.

Change the sub call to

Call processnaTEST(s)
'Change sub declaration to

sub processnaTEST(s as Integer)

 

[Jake975]

thanks I had got the variable working with the full name and I cant do it the way your suggestion because the variable is changed by the userform click so I have to use the whole name so i can rerun the macro so the information can be changed.
thanks for the suggestion i will keep it in mind for the future.
Im currently stuck on the looping part so it doesn't freeze excel. if you have any suggestions on that it would be a huge help.