I am sure this is an easy one for a master of vba out
their ?

I am inputting dates in textboxs (within a userform) in
the following format dd\mm\yyyy (UK Standard format).

However when I call it back from the spreadsheet to my
userform it returns mm\dd\yyyy (USA format).

When I check the spreadsheet it is UK format are textboxes
automatically use USA format and if so can I force my
textbox to except my UK format.

Many thanks in anticipation

Marcus

ActiveCell.Value = cDate(Textbox1.Text)

Textbox1.Text = ActiveCell.Text

should respect the UK format.

--
Regards,
Tom Ogilvy


"Marcus Walker" wrote in message
...
I am sure this is an easy one for a master of vba out
their ?

I am inputting dates in textboxs (within a userform) in
the following format dd\mm\yyyy (UK Standard format).

However when I call it back from the spreadsheet to my
userform it returns mm\dd\yyyy (USA format).

When I check the spreadsheet it is UK format are textboxes
automatically use USA format and if so can I force my
textbox to except my UK format.

Many thanks in anticipation

Marcus