I have a problem in visual basic for excel.
Introducing a date in a textbox in dd/mm/yyyy format appears in the related cell as introduced in the userform.
However, resetting a date from a cell into the userform, transforms the date in mm/dd/yyyy
So far I solved this problem by splitting dates in three text boxes, one for the day, one for the month, and one for the year. This work around conflicts with the restriction on the maximum number of text boxes and drop down boxes one excel file can contain ( about 500 I think, perhaps there’s no restriction as such, but when I develop userforms with more than 500 boxes, I get an error )
Do you have a solution for this "date resetting" problem ?
in attachement you'll find a simple example illustrating this issue