how do i get this code to wait for a command button click first?
VBA Code:
Sub ProcessnaTEST()
'Dim answer As NightAuditP.Button1.Caption
'answer = buttonText
Call intprogress
NightAuditP.Question.Caption = ("Are you ready to start the night audit file process?" & vbNewLine _
& "This is for the date of: " & Format(Date - 1, "mm-dd-yyyy"))
If answer = Yes Then
' Call PNT2
MsgBox "Nihgt Audit Checklist printed"
'Call pmtpause
'Call Makefolder
'Call FolderPicker
' Call Msgbox_1A
ElseIf answer = vbNo Then
MsgBox "Click Start prior to running audit in Opera when ready.", , "Night Audit Processing"
Else
'Call Reset
End If
End Sub