I think I'm making this harder than what it is.
I would like to prompt the user for an integer that represents a month. Ex - 9 for September
and have some data validation. However, I seem to be caught in the if statement.
Suggestions are greatly appreciated.
Check = False
If ReportMonthInt < 1 Or ReportMonthInt > 12 Then
Check = True
MsgBox "Please enter a valid integer value for a month between 1 and 12.", vbOKCancel
If vbOKCancel = 2 Then
ReportMonth = InputBox("Enter the numeric month to query?", "Report Month", DefaultMonth)
If ReportMonth = "" Then
Else: Check = False
Loop While Check = True