tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,834
- Office Version
- 365
- 2019
- Platform
- Windows
I want a set of dates on Sheet1 to populate a combobox on a userform.
Despite the dates on Sheet1 are dd/mmm/yyyy format, when the userform pops up, it reverts to mm/dd/yyyy.
How can I change it?
Thanks
Code:
Private Sub UserForm_Initialize()
Dim DateRng As Range
Set DateRng = Sheet1.Range("A1:A100")
Me.cmbDates.List = DateRng.Value
Me.cmbDates.Value = Format(cmbDates, "dd/mmm/yyyy")
End Sub
Despite the dates on Sheet1 are dd/mmm/yyyy format, when the userform pops up, it reverts to mm/dd/yyyy.
How can I change it?
Thanks