PDA

View Full Version : Fixed formatting of combobox?



jsabo
08-21-2015, 01:39 PM
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
08-21-2015, 05:01 PM
Format the cell the dropdown is in?