I enter todays date into a sheet via a userform as follows:-
I have also formatted A1 as a date with the same formatSub FillForm() Todaysdate = Format(date,"dd/mm/yyyy" Me.IndateTb.value = Todaysdate Sheets("Sheet1").Range("A1").Value = Me.IndateTb.Value End sub
However when I read back the value it always shows in the textbox as mm/dd/yyyy.
How can I stop this?
John Southern
Bookmarks