Diving_Dan
Board Regular
- Joined
- Oct 20, 2019
- Messages
- 161
Hi all,
I know I've had this problem before I can't remember for the life of me how to fix it.
I have a userform that displays data from a worksheet. It is one line of code that is causing me problems
The date is stored in the worksheet in the format of dd/mmm/yyyy but when it is shown on the userform is shows as mm/dd/yyyy when I would like it to remain in the same format as the worksheet.
Any help will be greatly appreciated as always.
Dan
I know I've had this problem before I can't remember for the life of me how to fix it.
I have a userform that displays data from a worksheet. It is one line of code that is causing me problems
VBA Code:
Me.txtTsCsAcceptedOn.Value = ActiveCell.Offset(, 8).Value
Any help will be greatly appreciated as always.
Dan