Date / Day format

[ElmerS]

Hi,

In a worksheet it is easy to display the weekday of todays day - for example:

Todays day in Turkish is: "Sali" and in German: "Dienstag".

This can be achieved formatting the cell as: [$-041F] dddd or [$- 0407] dddd.

What I want is to present these two day formats in VBA in a MsgBox command WITHOUT any Sheet cell help.

I have tried:

Please Login or Register  to view this content.

and:

Please Login or Register  to view this content.

but what I get, in both cases, is the same local weekday and not the Turkish or German one.

Is there a solution to my question.

Thanks in advance, Elm

[Richard Schollar]

Hi Elm

You could use the WorksheetFunction class:

Please Login or Register  to view this content.

Richard

[ElmerS]

Thank you.

I feel a little stupid because the usage of the WorkSheetFunction is not new to me.

As a matter of fact I usually omit the WorksheetFunction and use a shorter command:

Please Login or Register  to view this content.

From your reply I understand that this is the only way to produce such a formatted day - or...!?

Thanks again Elm