Hi, If I enter a date in worksheet1 cell a5 that is earlier than today, a message Yes No should appear on the screen. Does anyone have a code for this? thanks