Good day to all, I am a newbie trying to get a date in the English format
i.e. dd/mmm/yy into a combo box on a userform. My problem is that the
RowSource of the Combo Box is a sheet cell which shows the correct format,
the drop down list shows the correct format, but when it is selected the
Combo Box shows an excel serial number, or depending on format the date in
the American style i.e. mmm/dd/yy. Is it possible to do what I want?

Any help would be much appreciated.
Many thanks
Graham