here I attached two different sheets are there
If today is 05/09/2014 then user can enter date in date column from 03/09/2014 or 04/09/2014 or 05/09/2014
he should not allow to enter date before 03/09/2014
then system will give massage like cant enter date before 2 days
Two different sheets are there One is row wise date and one is column wise date
Please help to restrict data entry for both sheets
Atul
use the worksheet change event
Please Login or Register to view this content.
Last edited by JBeaucaire; 09-05-2014 at 10:09 AM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
I am not aware with VBA Codidng
So I cant write target value
Please elaborate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks