Results 1 to 5 of 5

Thread: Data validation

  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have some data validation set to allow from list. There are only 4 items in the list and I would like to populate each item by typing the first letter, but this does not happen. Is there a setting somewhere?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Alas, that is not possible with Validation - a serious limitation!

    One possible workaround is to use one-letter items and to use lookup formulas to display the description in the next cell to the right. But it's not ideal...

    The combo box from the Control Toolbox does support automatic completion, but the user has to click in the combo box, you can't tab into it as you can into a cell...

  3. #3

  4. #4
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='VegasNath' post='784996' date='16-Jul-2009 23:45']I have some data validation set to allow from list. There are only 4 items in the list and I would like to populate each item by typing the first letter, but this does not happen. Is there a setting somewhere?[/quote]
    Another possible workaround, since you only have four items on your valid list, is to enter each of the allowable entries at the top of your data column (these rows could then be hidden). Entering the first letter below would then automatically show the full entry with auto-complete. I don't know if you would find this suitable in your case.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  5. #5
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='BilasTasol' post='785096' date='17-Jul-2009 17:25']Another possible workaround, since you only have four items on your valid list, is to enter each of the allowable entries at the top of your data column (these rows could then be hidden). Entering the first letter below would then automatically show the full entry with auto-complete. I don't know if you would find this suitable in your case.[/quote]

    My apologies for not responding sooner. This is an excellent idea, with a lot of jiggerypokery required!

    I'll attempt to introduce this in my next version. Thanks

Posting Permissions

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