Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: over-ride combo box

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    tucson
    Posts
    94
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have an quote request form that my customers can fill out. much of the form is combo lists that I have predetermined the content. I need to know if there is a way for the customer to over-ride the combo box and type their own entry into the box if the choice they desire is not in my predetermined database.
    p.s. I am using MAC OS9 if that makes a difference.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you're using a Control Toolbar ComboBox, you can set the MatchRequired to FALSE.

    If you're using a Forms Toolbar ComboBox, don't know if it's possible.

    If you're using Data Validation, just UNCHECK the Show Error in the third tab.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    tucson
    Posts
    94
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, I'll try those options. I am, in fact, using a Forms ComboBox, so this gives me two more options to attempt.


  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Marley

    Not sure if it would be an option, but have thought about using a Validation list?

    Or, if you stick with the Forms ComboBox you could use a Dynamic range and have new entries added straight to that range, which would then incorporate the new entry as part of the CombBox "Input Range:"

    http://www.ozgrid.com/Excel/DynamicRanges.htm



  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    tucson
    Posts
    94
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have swithced from a Forms Toolbar ComboBox to the DataValidation and UNCHECKED the show Error and it is working perfectly. This website is absolutely priceless. Thank you all who participate.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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