MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formatting combo boxes in userforms

Posted by judi on October 12, 1999 10:44 AM

I created a userform with a combobox which lists dates from my workbook. The dates are formatted as dates (mm/dd/yyyy) in the workbook, but when I select the appropriate date from the drop-down list when running the userform the date selected is returned in serial format (ex 35986) Is there a way to format the return value on the combobox so it lists the date and not the date's number?



Posted by Chris on October 12, 1999 10:56 AM


If you returned the value of the combobox to a variable x, then you could change it as follows:

x = Format(x, "mm/dd/yyyy")