Dear xls Gurus,
I have a sheet in which 2 colimns H and J are devoted for date.
There is a code behind which enables pop up calendar for population of those dates when user press and cell.
date in column H should be smaller than date in column J.
example file:
How I can introduce a new function which will check that condition? If it is not fullfilled lets pop up a message "Error-dateJ should be >dateH"
Thanks!
Try this.....
Include the following code for Worksheet_Change Event. To do so, right click on the sheet tab --> View Code --> and paste the following code in the code window.
Does this help?
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Another method...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Dear SKTNEER,
I just added your code below the code that makes the calendar to pop-up.
It works!!! Thanks a lot!!!!
BR,
Erkamu
Dear Alphafrog,Originally Posted by AlphaFrog
I use your code but it did no work. Anyway-thank you!
BR,
Erkamu
Dear friends.
I did some further test and spotted something that I would like to fix.
That code:
does the job but I spotted that whenever I trigger an error msg to apear then the cell format is changed. For example in format cell-->protection tab locked indicator got ticked. Before the error it was not locked. Also the dat format in that cell changes from dd-mmm-yyyy to mm/dd/yyyy.Please Login or Register to view this content.
How the code should be adjusted so after
cells are not changing its proporties.Please Login or Register to view this content.
In general the whole sheet is protected and when lock indicator changes from unlock-to lock that makes imposible next data entry in respective cells.
BR,
Erkamu
Instead of using Target.clear use Target.ClearContents so that the formatting will remain intact within the target cell.
If that takes care of your original question, please mark your thread as solved by selecting Thread Tools --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.
Last edited by sktneer; 06-01-2014 at 06:53 AM.
Just did it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks