VBA check if date is holiday

Hi

I am new to vba
I been trying to use vba to check if a date is a holiday from a holiday table
Below are my code but the code doesnt seen to work

Please Login or Register  to view this content.

Any help would be appreciated

Thanks and Best Regards,
Kenneth