Help needed to edit macros due to change in data range

I have a workbook that is used as a booking system and one of the macros inside this workbook enables the name of the person who has booked the room at that time to show up when I hover my mouse over the cell which is highlighted.

Original.zip

After feedback from my users, we have decided to switch the columns for "Room" and "Date" such that "Date" is in column B and "Room" is in column C for the "For View; Make Reservation" sheet in the workbook.

Revised.zip

The problem now is that the macros doesn't work when these 2 columns are switched. Would anyone know how to modify the existing macro so that it works?

Hi Mike,

Thanks for that! However, I just realised that the "Check Availability" sheet does not update itself automatically when the date in D3 is changed. Instead, every time I changed the date, I have to go to the "View ; Make Reservation" sheet and then back to the "Check Availability" sheet before it can be updated. Is there any macros which I can use to update it automatically?

Thanks Mike! You're a genius!!!