deepheat101
Board Regular
- Joined
- Jul 26, 2006
- Messages
- 138
Hi All...
I need all the drop down items (dates) within a ComboBox on a form to appear in the format dd-Mmm-yyyy. The source range is in the required format. I would have thought that the ComboBox would be populated using the following...
...but, obviously, this does not work. Anyone care to offer a suggestion?
Many Thanks
Dave
I need all the drop down items (dates) within a ComboBox on a form to appear in the format dd-Mmm-yyyy. The source range is in the required format. I would have thought that the ComboBox would be populated using the following...
Code:
ComboBox1.List = Format(Range("F18:F" & LastRow).Value, "dd-Mmm-yyyy")
...but, obviously, this does not work. Anyone care to offer a suggestion?
Many Thanks
Dave