Formatting userform textbox - help required

  • Thread starter Thread starter Kennyatwork
  • Start date Start date
K

Kennyatwork

Hello All

I have created a command button which when clicked enters the date and time
into a textbox on my userform by using a sub - TextBox1.value=Now()

My problem is it enters in M/D/YYYY_H:M:S format and, being British, I
require D/M/YYYY_H:M:S format.

As I could not find a way of altering the date property of the text box I
attempted to add TextBox1.Format=D/M/Y_H:M:S into my sub but this only
created an error!

Could someone please advise on the correct method of acheiving what I
equire

TIA

Kenny
 
Kenny,

Try

TextBox1.value=Format(Now(),"D/M/YYYY_H:M:S")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Good, should be Kennyathome soon.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top