Microsoft Office Forums - View Single Post - Change format of date when using Now function in VB code

Thread: Change format of date when using Now function in VB code

View Single Post

Old

03-02-2012, 11:51 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

You need to use the Range.NumberFormat property. Something like this:

Code:

With Range("T" & target.Row)
    .Value = Now
    .NumberFormat = "dd/mm/yy - hh:mm"
End With

__________________
Colin

RAD Excel Blog

Reply With Quote