PDA

View Full Version : Highlight and popup message Between employee dates are overlap using (vba)



sathishsusa
02-13-2017, 12:33 PM
Hi,

I need the vba code for leave planning can u help me out to solve .
Highlight and popup message to show the overlap dates by each months between two or three employees by selecting check box in column “ AR” & "AS" Reference name search from whole year (January to December ) calendar.
Once overlap days are there between employees then msgbox should appear like
” overlap between those employees
Employee01 from [ date] to [date]
Employee02 from [ date] to [date]
Employee04 from [ date] to [date]” vbok and cancel button
And also highlight those days in red color in “yearly planner sheet” in calendar else msgbox ” there is no overlap between those employee “ with vbok and cancel button.

Red color which is showing only for information to look overlap if i double click on macro button it should back to normal

i attached the sample file pls check it.