VBA module copies a date (dd/mm/yyyy) from a TextBox on sheet A to new Sheet B column B. All well until day >12 when it pastes the date as text only.
Code does
Code:
Cells(z, 2) = Format(TextBox2.Text, "dd/mm/yyyy")
PC is set for UK data 'short' format
Column B is set for date format dd/mm/yyyy
Cannot seem to crack this one!