Have a ComboBox that gets built by VBA.
I have attached the workbook (trimmed down to necessary items)
I cannot for the life of me get the ComboBox to show the correct date format (dd-mmm-yyyy) in the dropdown list, even though it shows the correct date when selected. Except for dates such as 10/7/2015 which reads as 10-Jul-2015 instead of 07-Oct-2015
Been at this for two days now, and need therapy.
Please help by running the macro attached to the button "DSV Procedure" on the PasteSheet. I have placed Stops in the code at each stage for analysis.
Any help would save me a trip to the shrink