Anything better than autocomplete?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: drewdog (drewdog.17rw8y_at_excelforum-nospam.com)
Date: 06/13/04 

Date: Sat, 12 Jun 2004 23:59:24 -0500

I'd like to allow the user to type a few letters and move to the item in
a list that starts with these.

In autocomplete, not only does the list have to be on the work*** in
question, but I believe it has to be in a contiguous cell (no spaces
between where you are entering and where the "autocomplete" info is).

I'm doing most of my lists with validation. List boxes are possible,
but I believe they are bulky data wise, and will swell the size of the
workbook, slowing it down (shared over a network).

Any thoughts?

Drew 

---
Message posted from http://www.ExcelForum.com/
Quantcast