Convert the following vba Date to French way.

I only know how to use it using an actual date like this

Please Login or Register  to view this content.

where
[$-C0C] is the format for canadian french
or maybe create a variable and use that instead of repeating the formula

Please Login or Register  to view this content.

so maybe code would look like this

Please Login or Register  to view this content.