sorry me again, it appears not to work and I have a macro security level
warning appear, the drilldown code didnt work i fear.

"Stacey" wrote:

Thanks for your reply

"Gord Dibben" wrote:

DV dropdown lists do not have Autocomplete capability.

For that feature you would need a Combobox helper.

See Debra Dalgleish's site for the how-to part.

http://www.contextures.on.ca/xlDataVal10.html


Gord

On Mon, 1 Dec 2008 18:01:01 -0800, Stacey
wrote:

Hi Thanks for that, however I would like to be able to drilldown by typing
the text, I have a large numeric & text list, and i need to be able to enter
a letter to drill down to the appropriate cell.

"Gord Dibben" wrote:

Usw arrow to keys to navigate to dropdown cell.

Alt + downarrow to open the list.

Arrow down to selection and ENTER key.


Gord Dibben MS Excel MVP

On Mon, 1 Dec 2008 17:19:02 -0800, Stacey
wrote:

when selecting data from my dropdown list, I would like to be able to use
keyboard to cursor to the required cell ... is this possible ?