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?