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.
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.