Hi all,

Not sure if this is a question for here or programming....

Anyone know how in a pull down list when you type the first letter (e.g
S) it will jump to the the first entry in the list with S and then if
you type E, it would jump to the first entry starting with SE?????

Thanks a bundle,

Chris


--
chris100
------------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166
View this thread: http://www.excelforum.com/showthread...hreadid=571564

If your drop-down list if from Data Validation, you cannot have Autocomplete.

Try a combo-box drop-down list.

Debra Dalgleish has instructions.

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


Gord Dibben MS Excel MVP

On Mon, 14 Aug 2006 17:14:49 -0400, chris100
wrote:


Hi all,

Not sure if this is a question for here or programming....

Anyone know how in a pull down list when you type the first letter (e.g
S) it will jump to the the first entry in the list with S and then if
you type E, it would jump to the first entry starting with SE?????

Thanks a bundle,

Chris

Thanks for the help Gord.

i finally got round to trying this one out and it works great. The
only thing is i'd like to limit the amount of mouse use by the user and
hopefully make things a little quicker.

Could you help me change the code where say pressing the shift key
activates the procedure?

As always thanks to all you helpful people...


--
chris100
------------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166
View this thread: http://www.excelforum.com/showthread...hreadid=571564

Sorry to bring this back up to the top but i think it's better than
creating a new post.

Does anyone have an idea to replace the doubleclick with something like
pressing the shift key twice or "shift+\". I'm not that good with VBA
but i figured this would make an already good piece of script be even
more user friendly....i hope.

Regards,

Chris


--
chris100
------------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166
View this thread: http://www.excelforum.com/showthread...hreadid=571564