+ Reply to Thread
Results 1 to 3 of 3

Combobox property "Match Required" has no apparent effect

  1. #1
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,792

    Combobox property "Match Required" has no apparent effect

    I developed the attached as a prototype to demonstrate how a combobox control can be set up in a worksheet. The request included the requirement to limit the user to being able to enter values only from the associated list. I set the "Match Required" property to True but the combobox still allows me to enter any value at all.

    Am I misinterpreting what this property does? Example attached.

    Quote Originally Posted by Excel Help
    If the MatchRequired property is True, the user cannot exit the ComboBox until the text entered matches an entry in the existing list. MatchRequired maintains the integrity of the list by requiring the user to select an existing entry.
    Attached Files Attached Files
    Last edited by 6StringJazzer; 03-25-2010 at 06:19 PM. Reason: solved
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  2. #2
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: Combobox property "Match Required" has no apparent effect

    Hi,

    See previous thread...
    http://www.excelforum.com/excel-prog...t-working.html

    HTH

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,792

    Re: Combobox property "Match Required" has no apparent effect

    Thanks for referring me to that. The specific post that answers the question is at

    http://www.excelforum.com/867801-post3.html

    The Style property must be set to fmStyleDropdownList.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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