Kris75
Board Regular
- Joined
- Jul 29, 2009
- Messages
- 143
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"
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"