uk us date

  1. Kris75

    Dates in Userforms

    Hi Guys I have a text box that when initalized sets the date as dd/mm/yy (01/05/10) this is good, but when i have clicked on my command button to submit the date it converts the date as 05/jan/10 what am i doing wrong? ActiveCell.Value = txtdate.Value ActiveCell.NumberFormat = "dd/mm/yy"

Some videos you may like

This Week's Hot Topics