i can add items to a combo box like so
what i wanna do is add a list of date howver the date format does not auto come up instead it is just numbers ? any ideas how to format a combobox in a form ?
i can add items to a combo box like so
what i wanna do is add a list of date howver the date format does not auto come up instead it is just numbers ? any ideas how to format a combobox in a form ?
I like the ms date and time picker control 6.0 it is designed to select dates
you should check it out
Last edited by davesexcel; 07-18-2007 at 08:08 AM.
thanks champ
I have the same problem i VBA, but didn't quite understand this solution. Is this some addon I have to download?
The datePicker Control ia an ActiveX control, generally available in the VBA Toolbox by right clicking & choosing Additional controls.
However, it is not always available and if you intend distributing the finished application you may find problems where the end user does not have this control on their PC.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks