Hello Gents.
I have a question;
On a userform I have a combobox (2 columns) that shows a long list of dates.
Code of the Box:
This Shows the date in the Combobox as DD/MM/YY.
However, I'd like to add the notation of the day.
In the Celproperties the notation would be:
In the source of the datebox I changed the cell notation to the above, but it has no influence of the notation in the Combobox.
Thanks in advance.
I have a question;
On a userform I have a combobox (2 columns) that shows a long list of dates.
Code of the Box:
Code:
Set dte = Worksheets("Datum")
With dte
LastColumn2 = .Cells(1, .Columns.Count).End(xlToLeft).Column
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
Set DateList = Range(.Cells(1, 1), .Cells(LastRow, LastColumn2))
End With
With DateBox
.ColumnCount = 2
.ColumnWidths = "70;15"
.List = DateList.Value
End WithHowever, I'd like to add the notation of the day.
In the Celproperties the notation would be:
Code:
ddd dd-mm-jjThanks in advance.
