mopey12345
Board Regular
- Joined
- Nov 26, 2020
- Messages
- 76
- Office Version
- 2010
- Platform
- Windows
Hi
Help needed please. I have tried various tips but still struggling to stop the input userform txt_start_date_box dd/mm/yy writing to the spreadsheet and changing the date format to mm/dd./yy
eg. Range("A2").Value = Format(Format(txt_start_date.Value, "Long Date"), "DD/MM/YYYY"). Tried ,value and .text but no luck. Any help appreciated. Thanks Phil
Help needed please. I have tried various tips but still struggling to stop the input userform txt_start_date_box dd/mm/yy writing to the spreadsheet and changing the date format to mm/dd./yy
eg. Range("A2").Value = Format(Format(txt_start_date.Value, "Long Date"), "DD/MM/YYYY"). Tried ,value and .text but no luck. Any help appreciated. Thanks Phil