Set Date Format in VBA Code

[tlc53]

Hi,

I have a VBA code which is working great for me, however I want to define the date format on cell A3 to dd.mm.yy
How do I incorporate it into this extract of coding?

strName = wsA.Range("A1").Value _
& " - " & wsA.Range("A2").Value _
& " " & wsA.Range("A3").Value

Thank you!

 

[alansidman]

change this:

wsA.Range("A3").Value

to

Format(ws.range("A3"),"dd.mm.yy")[/COLOR]

 

[tlc53]

Thank you! I just put an "a" after the "ws" and it did the trick.
The code is now causing another problem which I have posted a separate posting about.

Thank you for helping me with this!