Selected Answer
This issue isn't, frankly, to be solved by the tqarget group of Don's tutorial, as Don's own answer demonstrates. The point is that Excel records a date as a number, an integer for a day and a fraction for the time of day. Jan 8 2018 = 43473, and 43473.5 would be 12 noon on Jan 8, 2018. Depending upon your cell format that number would be displayed as Jan 08, 2018 12:00:00 or 1/8/18 or simply Tue, to show just a few variation.
Now, when you look for a date which value should you look for? The number or the display? By asking you to look at the Formula, Don was hoping to let you catch the number. It didn't work out. The look-up value must be of the same format as the looked-for value.
Correct me if I'm wrong, but I think that you neither set the date format for E6 (in your Form), nor in the Data list. If so, both were set to Excel's default (which is controlled by Window's Regional Settings). The odd one out is the InputBox, however, which returns a string. It isn't of the same format as the others. Therefore I suggest you try this Find command in your Module3
Set Rng = dataIDCol.Find(What:=CDate(searchValue), _
LookIn:=xlFormulas, _
LookAt:=xlWhole, _
SearchOrder:=xlByRows, _
MatchCase:=False)
CDate(searchValue) will convert the date you entered in the InputBox to the default date format, and that should be the same as happens to be in the look-up column.
The solution worked on my PC and I hope it will work for you too. If it doesn't we have to look further among the different formats of your dates.