I have a forms combo box in a worksheet. It is attached to a range. It is a
long list. Is there a way to type the first few letters and get the list
moved to that item?

Thanks
MVM

I believe you would need an ActiveX/Control Toolbox combobox to do this.

--
Regards,
Tom Ogilvy

"MVM" wrote in message
...
I have a forms combo box in a worksheet. It is attached to a range. It
is a
long list. Is there a way to type the first few letters and get the list
moved to that item?

Thanks
MVM

Tom,

This seems to work with Combobox & Listbox,
(entry match as characters are entered).

but is there a way to do this with Data Validation (from a list)?

--
steveB

Remove "AYN" from email to respond
"Tom Ogilvy" wrote in message
...
I believe you would need an ActiveX/Control Toolbox combobox to do this.

--
Regards,
Tom Ogilvy

"MVM" wrote in message
...
I have a forms combo box in a worksheet. It is attached to a range. It
is a
long list. Is there a way to type the first few letters and get the list
moved to that item?

Thanks
MVM

I know it works with controls from the control toolbox toolbar (combobox and
listbox) - the believe was in reference to the ability to do it with the
dropdown control from the forms toolbar - which I can say with slight
reservation is not possible (someone may have a clever coding solution
subclassing excel or something). For the Data Validation list, it is not
supported in the same way as the forms dropdown.

--
Regards,
Tom Ogilvy

"STEVE BELL" wrote in message
news:4AQHe.36258$S%5.7165@trnddc06...
Tom,

This seems to work with Combobox & Listbox,
(entry match as characters are entered).

but is there a way to do this with Data Validation (from a list)?

--
steveB

Remove "AYN" from email to respond
"Tom Ogilvy" wrote in message
...
I believe you would need an ActiveX/Control Toolbox combobox to do this.

--
Regards,
Tom Ogilvy

"MVM" wrote in message
...
I have a forms combo box in a worksheet. It is attached to a range.
It
is a
long list. Is there a way to type the first few letters and get the
list
moved to that item?

Thanks
MVM

Tom,

Thanks... (I was hoping...)

--
steveB

Remove "AYN" from email to respond
"Tom Ogilvy" wrote in message
...
I know it works with controls from the control toolbox toolbar (combobox
and
listbox) - the believe was in reference to the ability to do it with the
dropdown control from the forms toolbar - which I can say with slight
reservation is not possible (someone may have a clever coding solution
subclassing excel or something). For the Data Validation list, it is not
supported in the same way as the forms dropdown.

--
Regards,
Tom Ogilvy

"STEVE BELL" wrote in message
news:4AQHe.36258$S%5.7165@trnddc06...
Tom,

This seems to work with Combobox & Listbox,
(entry match as characters are entered).

but is there a way to do this with Data Validation (from a list)?

--
steveB

Remove "AYN" from email to respond
"Tom Ogilvy" wrote in message
...
I believe you would need an ActiveX/Control Toolbox combobox to do this.

--
Regards,
Tom Ogilvy

"MVM" wrote in message
...
I have a forms combo box in a worksheet. It is attached to a range.
It
is a
long list. Is there a way to type the first few letters and get the
list
moved to that item?

Thanks
MVM