| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 20660 | 2002-06-09 21:57:00 | Excel - Combo Box & Dates | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 53489 | 2002-06-09 21:57:00 | Hi, I have a combo box in Excel that refers to a range in another sheet to get it's values. The value in the box show dates but after selecting a value the date changes to a serial date in the combo box and the destination cell has a serial also. Any tips on the VBA statements or property values to use? cheers Graham |
Guest (0) | ||
| 53490 | 2002-06-10 01:31:00 | The following code I found may help you. Private Sub ComboBox1_Change() ComboBox1.Value = Format(ComboBox1.Value, 'mm/dd/yy') End Sub |
Guest (0) | ||
| 1 | |||||