Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Canton, Ohio, USA
    Posts
    270
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Validation List (Ver 97, WIN 98)

    I am using data validation with the list option for several cells in a data user form. I have a user form where I would like to have the drop down list to choose from but permit the user to override the formula by entering an item that is not on the list. Instead of data validation, I'm really using the drop down list to speed up data entry and don't wish to capture every situation with the validation drop down list (i.e., list would be come too long and cumbersome). Is there anyway to create a drop down box the user can select from to fill the cell and also permit the user to type in an answer if the item is not on the list without getting an error message that occurs when "pure" data validation is used? Is this something that can only be accomplished through VBA? THANKS.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Validation List (Ver 97, WIN 98)

    You can use a combo box (from CONTROL TOOLBOX) with the fill range linked to a range of values.
    The combobox allows (if the MatchRequired property is false) a new value to be entered.

    The combo box would link to the cell you want to add the item to.

    No VB is required. Though you need to add a separate comboboxes for each the "several" cells.
    Steve

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Location
    Midland, Michigan, USA
    Posts
    133
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Validation List (Ver 97, WIN 98)

    I was able to do what I think you're asking by using data validation.

    I created a list of possible values for the cell, and set up data validation for another cell. I unchecked the "Show error alert..." box from the Error Alert tab, and likewise unchecked "Show input message..." from the Input Message tab. From there, I just did the normal data validation stuff: Allowed a list, set the source, checked the appropriate check boxes.

    If I decide not to use the list, I'll just type my own entry in the cell - ignoring the list completely.

    Does the attached illustrate well enough, or did I completely miss the question?

  4. #4
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Canton, Ohio, USA
    Posts
    270
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Validation List (Ver 97, WIN 98)

    Perfect....Many, many thanks! <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

Posting Permissions

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