EzzatHesham
New Member
- Joined
- Jun 10, 2022
- Messages
- 7
- Office Version
- 2016
- Platform
- Windows
Hello, everyone
I made an userform for filtering data based on dates. The userform has 1combobox it contains the dates data and its placed in: sheet7.range("h2:h69").
and 1listbox it contains the filtered data and its placed in:
Sheet9.range("l1").currentregion.
And that data showed in listbox contains another dates in column (m) in sheet and column 2 in listbox.
My problem is the date format.
Dates appears in combobox and listbox like (mm-dd-yyyy).
Any help to fix it to appears (dd-mm-yyyy)
Thanks.
I made an userform for filtering data based on dates. The userform has 1combobox it contains the dates data and its placed in: sheet7.range("h2:h69").
and 1listbox it contains the filtered data and its placed in:
Sheet9.range("l1").currentregion.
And that data showed in listbox contains another dates in column (m) in sheet and column 2 in listbox.
My problem is the date format.
Dates appears in combobox and listbox like (mm-dd-yyyy).
Any help to fix it to appears (dd-mm-yyyy)
Thanks.