DharmeshKP
New Member
- Joined
- Feb 15, 2020
- Messages
- 34
- Office Version
- 2007
- Platform
- Windows
I have user for with
TextBox3.Text = Format(Date, "dd/mm/yyyy")
then on cmd save code is like
.Cells(x + 1, "C").Value = TextBox3.Text
but in data sheet date formet changes and becomes "mm/dd/yyyy"
I have tried with formeting cells to date"dd/mm/yyyy" but still date format remaints incorrect
Please guide me
TextBox3.Text = Format(Date, "dd/mm/yyyy")
then on cmd save code is like
.Cells(x + 1, "C").Value = TextBox3.Text
but in data sheet date formet changes and becomes "mm/dd/yyyy"
I have tried with formeting cells to date"dd/mm/yyyy" but still date format remaints incorrect
Please guide me