right now I have this code, I have tried variations of it but can't seem to get it to work. no mater what the date is in Rng1 the msgbox appears.
Please Login or Register to view this content.
right now I have this code, I have tried variations of it but can't seem to get it to work. no mater what the date is in Rng1 the msgbox appears.
Please Login or Register to view this content.
Why not just use Conditional Formatting?
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks for the reply Roy,
I tried that too. even made sure rng1 on the spread sheet is cell format to date *m/dd/yyyy
You don't set rng1.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks