Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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, |
#2
|
|||
|
|||
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, . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Ploting dates against a calendar and not as a simple events | Charts and Charting in Excel | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
combo box formatting | Excel Discussion (Misc queries) | |||
How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) |