Posts by João Guilherme • 1 point

• -1

  votes

  2

  answers

  440

  views

  A: VBA reverses day with month in variables of type Date

  I found a solution to the problem. Enter the data like this in excel: Sheets("Example"). Cells(1, 1). Value = Dateadd("yyyy", 0, VBA.Format(Userform1.Textbox1.Value, "dd/mm/yyyy")) Works 100%…

  excel vba date excel-vba visual-basic-6

  answered 3 years, 9 months ago João Guilherme 1