I'm not sure if you can format the combobox to do that, but you can with the
list of dates. With the date in A1, in B1 try
=TEXT(A1,"dd mmm yy")
and use column B in the UserForm,
Regards,
Alan.
"Brad" wrote in message
oups.com...
I've designed a userform that requires dates to be selected from a list
of dates. When an item is selected it shows as the numeric version of
the date in the userform. Is there any way to format the combobox so
it presents in date format?