• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 826
  • Last Modified:

Command button help

Private Sub CommandButton2_Click()

ActiveCell.Value = DateValue(Date)
ActiveCell.Offset(0, 1).Select

End Sub

How do I determine the format to always be "dd/mm/yy" ?

Thanks for your help
1 Solution
NorieVBA ExpertCommented:
Use the Format function.
ActiveCell.Value = Format(Date, "dd/mm/yy")

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now