UserForm including TextBox with date (UK format)

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John Elink (john_elink_at_hotmail.com)
Date: 11/30/04 

Date: 30 Nov 2004 05:17:28 -0800

Hello

I have database which includes also dates in UK format (dd.mm.yyyy). I
am able to display everything using UserForm with TextBoxes, but dates
are displayed in US format (mm/dd/yyyy).
I am able to change that when I leave the TextBox where is the date
using the following procedure

Private Sub TextBox13_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Dim dt As Date
    dt = TextBox13.Text
    TextBox13.Text = Format(dt, "dd.mm.yyyy")
End Sub

but the question is - is there some way to display date in UK format
immediately when UserForm with the TextBox including date is
displayed? (after UserForm.Show)? so there is no need to go into the
TextBox with date?

Thanks for the comments
Regards
Johny

Relevant Pages

  • Re: Pull Recipient from Outlook Address book
    ... When you describe the scenario and state "(should then be in the textbox to ... I set up the following sub for the UserForm Activate event. ... What I'm trying to do, is thru an excel userform, open up the outlook ... The Outlook Display Name is the name that recipients see in emails. ...
    (microsoft.public.excel.programming)
  • Re: how do i create a form so that a selected check box shows time
    ... txtEnd and txtElapsed and a command button cmdClear ... Then use the following code in the UserForm: ... the txtStart textbox as HH:mm:ss and when the chkEnd checkbox is checked, ... txtElapsed textbox will display the elapese time, ...
    (microsoft.public.word.tables)
  • Re: Custom Cell Format problem
    ... I am having trouble with this "raw" TextBox. ... when I paste the contents of the UserForm into a new row on the sheet ... I have raw data in the format of 3 numbers, ...
    (microsoft.public.excel.programming)
  • Re: TextBox with comma formatting
    ... If the user inputs numeric characters simply add them to the TextBox ... but display them in thousands comma format. ... [You might even want to define your own custom clipboard format. ...
    (comp.lang.basic.visual.misc)
  • Re: Custom Cell Format problem
    ... I am having trouble with this "raw" TextBox. ... when I paste the contents of the UserForm into a new row on the sheet ... I have raw data in the format of 3 numbers, ...
    (microsoft.public.excel.programming)