Hi again,
Excel triggers the "Worksheet_SelectionChange" event whenever a cell or range of cells is selected.
The "If" statement first checks that only a single cell is selected, and then checks that there is a valid intersection between the selected cell ("Target") and cell A5 ("strCalendarCell") - in this case, a "valid intersection" means that the selected cell and cell A5 are one and the same.
When the "If" statement returns a value of TRUE, the "frmCalendar.Show" statement is executed.
Regards,
Greg M
Bookmarks