What happened when you tried replacing the Data|Validation cell with a combobox
from the control toolbox?

sedonovan wrote:

at the moment - its through data validation.

in sheet 2 i have a list of names and number

A | B
Name | Number
Tom | 123
Dick | 456
Harry | 789

in sheet 1 i've two columns A and B - again called name and number - when
i select Tom from column A , 123 appears in column b through vlookup.

but i need a facility to start typing the beginning of the name to match the
entry - can anybody help???

many thanks,
suzie

"sedonovan" wrote:



"Dave Peterson" wrote:

What did you use to create the drop downlist?

If you used data|Validation or a dropdown from the Forms toolbar, then nope.

If you used a combobox from the Control Toolbox Toolbar, then yep.

If you go into design mode, show the combobox's properties, you can play with
".matchentry".

sedonovan wrote:

if i have many entries in a drop down list, is there a way to start typing
and it goes through the entries to the value.

eg in the list there is

Daa..
Dab...
Dac...
Dafa.
Dafb.
Dafc.
Dag...
.
.
.
if I start typing Daf - it takes me only to the entries beginning Daf??

Many thanks
:)

--

Dave Peterson


--

Dave Peterson