Dear All
I am using a VBA created user form as a date picker in my workbook that works perfectly. However I would appreciate any assistance in overcoming a small challenge?
I need to validate a date entry cell, C30 (selected using the date picker) to only allow date entries greater than or equal to TODAY'S date.
Cell C6 contains formula =Today() and cell C30 is the date entry cell (using the date picker). Data Validation setting for cell C30 is: Allow = Custom, Data = greater than or equal to, Start date =C6.
But when I select a date earlier than the start date the in C30 it is still accepted.
Please help?
Thanks, Peter
Bookmarks