Hello!
I'm trying to find a way to verify that user input is in a specific format (specifically "mm/dd/yyyy"). Here's what I got:
Dim r As Long
Dim temp1 As String
r = MsgBox(prompt:="Are there any new records?", Buttons:=vbYesNo)
If r = vbNo Then
Do
temp1 = Application.InputBox(prompt:="Enter date of last change (mm/dd/yyyy):")
Loop While temp1 = "##/##/####" 'This is where the issue comes in
With Range("A7:I7")
.Merge
.Font.Bold = True
.Interior.Color = RGB(255, 255, 0)
.Value = "NO CHANGES SINCE " & temp1
End With
Else
Call WAWAFormatter
End If
Any help is greatly appreciated, thanks!
Bookmarks