auto complete for a list??

[Tangy]

I have a spreadsheet that I would like to have autocomplete cells
referencing to another spread sheet, basically a list of names.

How do I do this?
Thanks

 

[Tangy]

or I would like it to use autocomplete referencing all columns in the
document not just the column I am currently in, that would be even better.

 

[Gord Dibben]

Not possible without VBA


Post from Debra Dalgleish Dec 7, 8:39 pm

You could add a data validation list to the cells in the column.

Although data validation doesn't support autocomplete, there's a sample
file here that provides a combobox from which you can select one of the
values from the data validation list. In the combobox, you can enable
autocomplete:

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

Under 'Data Validation', look for 'Data Validation Combobox'


Gord Dibben Excel MVP

 

[Tangy]

I can 't find where to enable autocomlete in the combo box, can anyone else?

 

[Dave Peterson]

Make sure you used a combobox from the Control Toolbox toolbar--not a dropdown
from the Forms toolbar.

Then show that control toolbox toolbar
Click the design mode icon (top left icon (usually) on that control toolbox
toolbar)
Rightclick on the combobox. Choose properties.

Change the Style property to: fmStyleDropDownList
(to prevent users from typing in the combobox)

And then change MatchEntry to: fmMatchEntryComplete

Then click on the design mode icon (to turn it off) and test it out.