Datepicker, textbox & cells date-format does not match for formula to work

Hi,
I have userform1 ( Very small) and have 1 datepicker, Submit button & close button.

Date from datepicker is populated to sheet1 in column A

Column B contains formula for =TODAY() and indicates current date.

Userform2 is opened by doubl clicking column A
It had two textboxes ( 1- End date & 2 for current date ( both are populated from row A & B of sheet1

There is a Label1 aswell 'Due Now'

I am trying to achieve is that if the End date is less that current date, the Label1 is visible.

I may also like to amend the End date in userform2 .... trouble is here as well...the date-format

The issue may be with - formula =today() being deleted
buran is kind to give solution for this .... but at times it I have challanges .

http://www.excelforum.com/excel-prog...-userform.html

And

Date format of textbox , cells & datepicker do not match

It is very interesting one.
Spent a lot of time in understanding it, however it will not work.
I really & sincerely need some help please. Sample book attached
Kind regards

Hi Tinbendr,
Thanks.
I have now placed the formula in sheets rather than in textboxes and also using suggestions by buran.
It worked very well for one text box.
I now want to incorporate more textboxes, but making mistake while writting it.
Need final help for this thread.
Code is as follows:

Please Login or Register  to view this content.

Well done.
Thanks Kind regards

Hi Tinbendr,
Wonderful.
With above code it will not erase formule . However it will not save any changes made.
We are close to it now.
I have different approach.
Instead of getting into complex date format of DTpicker / text boxes, can we consider the following:
In following code, can we say that 'do not copy columns K, L, M, N to respective textboxes 11, 12, 13 14 ( as these will have formule)
Therefore no matter how many times we amend records, these columns will be untouched.

Please Login or Register  to view this content.

OR
We place formule in Row 1 ( which is untouched at all times). Then amend code to copy formule from row1 of columns K,L,M,N to the affected row cells using following code

Please Login or Register  to view this content.

Really great encouragement by you.
Thanks again

Here I am talking about actual worksheet columns and not about the sample file that I had attached.
Thanks

Hi,
I do agree with you.
Currently the issue now has been resolved through massive efforts and your kind support.
I will re-plan my learning strategy.
Learning will never end though.
Every problem will have 1 perfect solution and every perfect solution gives rise to two new challenges.
Because perfection has no limits.
Thanks again for your kind help and valuable time.
Once I fully prepare my project I will indeed take your opinion before finalizing it.
Kind regards