Results 1 to 14 of 14

Combo Box date format also to accept text

Threaded View

  1. #1
    Registered User
    Join Date
    10-06-2010
    Location
    Dunstable,England
    MS-Off Ver
    Excel 2010
    Posts
    95

    Combo Box date format also to accept text

    Hi I have a form with several combo boxes. The combo boxes are programmed to only accept a time format from the drop down list. But i alse have to alow the user to select either start or finish as a text option.


    the code I have so far is

    Private Sub FriFinish1_Change()
        Static Disabled As Boolean
        If Disabled Then Exit Sub
        Disabled = True
        FriFinish1.Value = Format(Val(FriFinish1.Value), "hh:mm")
        Disabled = False
            
    End Sub

    I have added the text options to the drop down, but when they are selected the program crashes and foes into debug mode. Does anyone know of a way to prevent this. The only text I want the user to select is start or finish.

    Many thanks
    Nods
    Last edited by nods; 11-18-2010 at 06:28 PM.

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