I want to select a text item from a long drop down list. Is there a way to
have a form of auto complete to help you search the list or do all methods
(eg: data,validation,list) require you to scroll up and down the list to find
the entry you want?
Thanks.
--
Peter
London, UK

Hi Peter,

Data validation does not natively provide autocomplete functionality.

However, Debra Dalgleish provides a possible workaround, using a combobox,
at:

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


---
Regards,
Norman



"Peter" wrote in message
...
I want to select a text item from a long drop down list. Is there a way to
have a form of auto complete to help you search the list or do all methods
(eg: data,validation,list) require you to scroll up and down the list to
find
the entry you want?
Thanks.
--
Peter
London, UK

Thanks Norman.
Can you suggest any other solution that does not involve VB code?
Thanks
--
Peter
London, UK


"Norman Jones" wrote:

Hi Peter,

Data validation does not natively provide autocomplete functionality.

However, Debra Dalgleish provides a possible workaround, using a combobox,
at:

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


---
Regards,
Norman



"Peter" wrote in message
...
I want to select a text item from a long drop down list. Is there a way to
have a form of auto complete to help you search the list or do all methods
(eg: data,validation,list) require you to scroll up and down the list to
find
the entry you want?
Thanks.
--
Peter
London, UK

Hi Peter,

The workaround enunciated by Debra Dalgleish is the only workaround of which
I am aware.

The implementation of Debra's code is very straightforward and she offers a
sample workbook which can freely be downloaded.

If you are not familiar with macros, you might care to visit David
McRitchie's 'Getting Started With Macros And User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


---
Regards,
Norman



"Peter" wrote in message
...
Thanks Norman.
Can you suggest any other solution that does not involve VB code?
Thanks
--
Peter
London, UK


"Norman Jones" wrote:

Hi Peter,

Data validation does not natively provide autocomplete functionality.

However, Debra Dalgleish provides a possible workaround, using a
combobox,
at:

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


---
Regards,
Norman



"Peter" wrote in message
...
I want to select a text item from a long drop down list. Is there a way
to
have a form of auto complete to help you search the list or do all
methods
(eg: data,validation,list) require you to scroll up and down the list
to
find
the entry you want?
Thanks.
--
Peter
London, UK

Many thanks Norman
--
Peter
London, UK


"Norman Jones" wrote:

Hi Peter,

The workaround enunciated by Debra Dalgleish is the only workaround of which
I am aware.

The implementation of Debra's code is very straightforward and she offers a
sample workbook which can freely be downloaded.

If you are not familiar with macros, you might care to visit David
McRitchie's 'Getting Started With Macros And User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


---
Regards,
Norman



"Peter" wrote in message
...
Thanks Norman.
Can you suggest any other solution that does not involve VB code?
Thanks
--
Peter
London, UK


"Norman Jones" wrote:

Hi Peter,

Data validation does not natively provide autocomplete functionality.

However, Debra Dalgleish provides a possible workaround, using a
combobox,
at:

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


---
Regards,
Norman



"Peter" wrote in message
...
I want to select a text item from a long drop down list. Is there a way
to
have a form of auto complete to help you search the list or do all
methods
(eg: data,validation,list) require you to scroll up and down the list
to
find
the entry you want?
Thanks.
--
Peter
London, UK

If you're only replacing one cell, the combobox from the control toolbox toolbar
won't require VBA.

If you're replacing cells with different lists, you could use a combobox for
each cell and still not require VBA.

Debra's code is very useful when you have (say) a column of cells that used the
same data|validation that you want replaced.

Peter wrote:

Thanks Norman.
Can you suggest any other solution that does not involve VB code?
Thanks
--
Peter
London, UK

"Norman Jones" wrote:

Hi Peter,

Data validation does not natively provide autocomplete functionality.

However, Debra Dalgleish provides a possible workaround, using a combobox,
at:

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


---
Regards,
Norman



"Peter" wrote in message
...
I want to select a text item from a long drop down list. Is there a way to
have a form of auto complete to help you search the list or do all methods
(eg: data,validation,list) require you to scroll up and down the list to
find
the entry you want?
Thanks.
--
Peter
London, UK




--

Dave Peterson

Thanks Dave
--
Peter
London, UK


"Dave Peterson" wrote:

If you're only replacing one cell, the combobox from the control toolbox toolbar
won't require VBA.

If you're replacing cells with different lists, you could use a combobox for
each cell and still not require VBA.

Debra's code is very useful when you have (say) a column of cells that used the
same data|validation that you want replaced.

Peter wrote:

Thanks Norman.
Can you suggest any other solution that does not involve VB code?
Thanks
--
Peter
London, UK

"Norman Jones" wrote:

Hi Peter,

Data validation does not natively provide autocomplete functionality.

However, Debra Dalgleish provides a possible workaround, using a combobox,
at:

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


---
Regards,
Norman



"Peter" wrote in message
...
I want to select a text item from a long drop down list. Is there a way to
have a form of auto complete to help you search the list or do all methods
(eg: data,validation,list) require you to scroll up and down the list to
find
the entry you want?
Thanks.
--
Peter
London, UK




--

Dave Peterson