In cell drop down type ahead

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Iain - 31 Jul 2008 17:48 GMT

Is there any way that you can make an in cell drop down be a type ahead
rather than a point and click?

Thanks

Reply to this Message

Debra Dalgleish - 31 Jul 2008 19:59 GMT

Data validation doesn't have an autocomplete feature. You can use a
combo box instead, as described here:

http://www.contextures.com/xlDataVal11.html

> Is there any way that you can make an in cell drop down be a type ahead
> rather than a point and click?
>
> Thanks

Signature

Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Reply to this Message