Help with existing pop up code

[Dazzawm]

I was given the codes within this thread http://www.mrexcel.com/forum/showthread.php?t=554868

Problem now is I have changed it from horizontal to vertical, so the names are going across the top and the dates down in column B. I need a pop up so that if someone has already an 'HP' in that date/row it will give a pop up saying 'such and such is already booked of that day' by looking at the name in row 3.

The names are ranging from C3:CB3 and the dates range from B4:B316

Thanks

 

[Dazzawm]

Change this Line (In red)
(I'm starting to forget what day it is !!!)

I think thats prob my fault! I think we are there thanks for everything.