Calendar Control bug?

[stevow]

Hi guys

I call upon the gurus again!

I have created a userform in excel, on this I have a the Calendar control (Microsoft Calendar Control 11.0).

I am having a huge problem outputting the date in the correct format on the worksheet. If the output date should be 09/12/2010 it will appear as 12/09/2010. If it is 13/12/2010 it outputs absolutely fine. It is almost as if the day number is before the month number it malfunctions?

Within the controls properties, you are able to change the date to System (English) which I did.

I have changed the formatting of the output cell in the worksheet to Custom and dd/mm/yyyy and also tried the Date formatting too. I have even customised the output in vba using the below.

Any help greatly appreciated!

Please Login or Register  to view this content.

[snb]

Please Login or Register  to view this content.

[royUK]

I never use calendar controls, they are always problematical.

Please Login or Register  to view this content.

[stevow]

Hi snb

As you changed the formatting, are you saying you need to first output it as american format, then let the worksheet formatting convert it?

Cheers

[stevow]

Got it to work with RoyUK's suggestion - MANY THANKS!

Note for others, if your sheet is protected, this needs to be unprotected to work. So the final snippet will be:

Please Login or Register  to view this content.

[royUK]

You can also use protectwithUserInterface if protected

For alternative calendar Controls see this

[stevow]

Many thanks!

[royUK]

No problem. If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save