Formatting a date in a combo box to M/D/YY

**imaquila** · 02-27-2012, 08:42 PM

My user form is coded to read the most recent date on my worksheet (which is already formatted as M/D/YY) and then load that date and the two dates following it to a combo box. For some reason the formatting for the dates has changed to display YYYY. Is there a way to keep the formatting from changing from what is stored on my worksheet?

Thanks for your help!

**davesexcel** · 02-27-2012, 10:01 PM

How is your ComboBox populated?

**nmhung49** · 02-27-2012, 10:09 PM

Try

Please Login or Register  to view this content.

Post file?

**imaquila** · 02-27-2012, 11:37 PM

Sorry, I wasn't very clear. It was the display in the combo box was using the "YYYY" format but I applied your suggestion to comboBox.AddItem code and it works great now.

Thanks so much for your help!