+ Reply to Thread
Results 1 to 3 of 3

ComboBox, Control, on Worksheet: MatchRequired NOT working

  1. #1
    Forum Contributor
    Join Date
    07-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    476

    ComboBox, Control, on Worksheet: MatchRequired NOT working

    Trying to keep typing functionality but limit user's typing to required items in Listbox

    MatchRequired is not working for some reason and I'm getting out of range error. I'm assuming the built in error handling is reverting value to 0 which throws of the code, but not sure. Before I break something, could use some help? Still learning VBA, not the best at coding in error handling.

    Reporting Tab

    TestsStart
    TestsEnd

    if type value TestsStart < TestsEnd = Problem
    if type value not in boxes = Problem

    Help?

  2. #2
    Forum Contributor
    Join Date
    07-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    476

    Re: ComboBox, Control, on Worksheet: MatchRequired NOT working

    help please?

  3. #3
    Forum Contributor
    Join Date
    07-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    476

    Re: ComboBox, Control, on Worksheet: MatchRequired NOT working

    If Sheet5.TestsStart.ListIndex <> -1 Then
    Code
    End If

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Control Toolbox ComboBox: Clear All cb when Worksheet Opens?
    By Agimcomas in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-26-2012, 01:45 PM
  2. UserForm - ComboBox - MatchRequired
    By yawnzzzz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2011, 03:24 PM
  3. control worksheet with combobox value
    By emmamaki in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-01-2008, 09:55 AM
  4. [SOLVED] Custom error-message for MatchRequired ComboBox
    By Gert-Jan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2006, 04:55 PM
  5. [SOLVED] OLE Combobox MatchRequired property not working
    By Michael Deathya in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-29-2005, 08:07 PM

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