Combo Box Showing numbers not dates
I have created a combo box with list of dates attached, but when I sellect a
date from the list, it appears as a number (not date format). How do I change this? Thanks, |
Try:
Private Sub ComboBox1_Change() With ComboBox1 .Value = Format(.Value, "mm/dd/yy") End With End Sub --- While in design mode, right-click on the combobox and select "View Code". HTH Jason Atlanta, GA -----Original Message----- I have created a combo box with list of dates attached, but when I sellect a date from the list, it appears as a number (not date format). How do I change this? Thanks, . |
All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com