Data validation

Topic

New Reply

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?

Reply | Quote

Replies

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…

Reply | Quote

That’s a pain!

Thanks for the suggestions.

Reply | Quote

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?

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.

Reply | 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.

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

Reply | Quote