+ Reply to Thread
Results 1 to 3 of 3

ComboBox Accept Choices Only?

  1. #1
    Registered User
    Join Date
    03-31-2009
    Location
    Auburn Alabama
    MS-Off Ver
    Microsoft Office Excel 2007 (Windows)
    Posts
    99

    ComboBox Accept Choices Only?

    Hello,


    My question is about limiting user input in ComboBoxes.

    I have a ComboBox with an array of added items. The items are all numbers. If the array provides a choice in the List of say, 1 to 108. How can i set the ComboBox so that the user can only type a number between 1 and 108, meaning only type what the choices are?

    I do not want him/her to be able to input anything else. No numbers that aren't a choice like say, 44882, and no strings.

    I DO want the user to be able to type in a number, however, and if the number is a choice in the List, the choice be found and shown.

    As of now, unfortunately, I'm free to type in any value... and if I type a value that's not in the array of items I get an error. So I'm hoping to prevent this.

    Thanks so much!!!!
    Last edited by CrazyFileMaker; 06-01-2009 at 10:35 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437

    Re: ComboBox Accept Choices Only?

    Change the style property of the control to dropdownlist
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-31-2009
    Location
    Auburn Alabama
    MS-Off Ver
    Microsoft Office Excel 2007 (Windows)
    Posts
    99

    Re: ComboBox Accept Choices Only?

    Andy,

    Such a simple solution! Thanks!!!

+ 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