+ Reply to Thread
Results 1 to 5 of 5

combo box format

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    05-14-2006
    Posts
    104

    combo box format

    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 ?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,523
    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.

  3. #3
    Forum Contributor
    Join Date
    05-14-2006
    Posts
    104
    thanks champ

  4. #4
    Registered User
    Join Date
    03-11-2007
    Location
    Norway
    Posts
    7
    I have the same problem i VBA, but didn't quite understand this solution. Is this some addon I have to download?

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1