Fixed formatting of combobox?

[jsabo]

Hello,

I have a combo box on one sheet that has selections of "MMM-YY". On the sheet, I have a private subroutine on that sheet that looks like:

Private Sub MonthDropDown_Change()
 MonthDropDown.Value = Format(MonthDropDown.Value, "mmm-yy")
End Sub

This successfully shows the selection in MMM-YY date format (i.e. Jan-15) instead of "42005" for instance.

When I move around the workbook and change sheets a few times, it reverts away from data format and becomes "42005" until i come back and reselect the date from the drop down menu.

Any ideas on how to fix this?

Thanks.

[SamT]

Format the cell the dropdown is in?