Hello Lewis,
You declared eDate as a Date Type. The Cancel button returns a Boolean type. To fix the problem, change eDate to a Variant Type.
![]()
Dim eDate As Variant eDate = InputBox("Enter the earliest date of the files you will be parsing." _ & vbNewLine & "Format: yyyy-mm-dd", "Enter Date", "yyyy-mm-dd") If eDate = "False" Then Exit Sub End If
Bookmarks