Textbox's and Dates the usual conflict

  • Thread starter Thread starter Marcus Walker
  • Start date Start date
M

Marcus Walker

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel is changing date format incorrectly 7
VB Date Format 8
Date on UserForm? 5
Textbox value 2
Userform 2
UserForm including TextBox with date (UK format) 2
Input message problem for Date textbox 4
Textbox date 1

Back
Top