I have a userform where combobox 7 is being populated from a list of dates in column Z on the sheet "List".
In the sheet the dates are in the format "dd/mm/yyyy" .When the combobox is populated it converts them to the format "dddd d mmmm yyyy" using the following code:
The dates are populating into the combobox perfectly fine. The problem is that when I try to convert it back to the original format, the macro doesn't recognize it as a date.
This is the code I'm using to convert the selected date back to the original format:
When I execute this code, I get a "type mismatch" error. Any ideas where I'm going wrong?
Bookmarks