date dd/mm reverts to mm/dd

[dantray02]

Hi the following code relates to a userform which on initialize picks up a date from a hidden worksheet. if the date is within the userform it then posts the changes to the same cell.

the problem I'm having is each time the commandbutton is clicked, regardless of whether changes are made the date reverts to and from dd/mm/yyyy - mm/dd/yyyy

Please Login or Register  to view this content.

it is the textbox2 i am concerned with.

[judgeh59]

I may be missing something but try this...

change the "dd/mm/yyyy" to "mm/dd/yyyy"

[dantray02]

Hi, Sorry no this does not work.

The problem is it switches each time, from dd/mm then I click the command button and it is mm/dd. the next time the button is pressed it changes again.

[judgeh59]

can you upload the file....sometimes it's easier to troubleshoot that way....please remove any company confidential stuff....

[dantray02]

hello - i am sorry for the delay. Please find example workbook attached. When the userform is displayed it should show the dates from the worksheet, which it does.

Any changes to the dates when the userform is shown should then transfer to the worksheet when the commandbutton is pressed, which it does.

The only problem is that the DD/MM format changes to and from MM/DD each time the command button on the userform is pressed.

sample file attached.

thanks in advance.

[cytop]

Rather than trying to format, let VBA figure out what's what with the dates according to your computer settings.

If you convert the text in a textbox to a date before writing to the worksheet, it will be written correctly:

Please Login or Register  to view this content.

[Fotis1991]

Try this.

Please Login or Register  to view this content.

[dantray02]

Hi yes, that's great thank you. However, one problem is that now if i clear the dates on the userform to post blank entries to the worksheet then I get an mismatch error?

How do I correct this?

What is the significance of "Me" in the code?

thanks again.

[Fotis1991]

Let's say that is the id of the textbox!..So.

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[dantray02]

hi, sorry - i will mark as solved and thank you. however, i had edited my last post no doubt whilst you were writing that so not quite solved yet.

thanks again in advance.

[Fotis1991]

1 way could be this.

Please Login or Register  to view this content.