Hello again
Sorry, I didn't realize that you wanted to do this with VBA. The workbook I attached only had an array formula on the 'Data' sheet in cell O3. You enter your search values in cells M3 and N3 and the booking message is returned in O3. Having now looked at your code, I think you perhaps know more VBA than I do. I'm not sure how to get array formulas to run in VBA. The only way that I might do it, is to link the form to the Data sheet formula. I think you'll have to search for both date and company to find a match, if I understand your problem correctly. Perhaps another user can help?
Bookmarks