Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
javervoo
 
Posts: n/a
Default How can you jump to a selection in a validation drop-down?

By using validation I can create a drop-down list in the field no problem.
I'm just wondering whether it is possible to add 'jump-to' capabilities to
it. ie: for a list containing Apple, Ball, Cat, and Doug, if you key in 'C'
it would jump to Cat.

Thanks!
  #2   Report Post  
Kassie
 
Posts: n/a
Default

Hi

See http://www.contextures.com/xlDataVal01.html


"javervoo" wrote:

By using validation I can create a drop-down list in the field no problem.
I'm just wondering whether it is possible to add 'jump-to' capabilities to
it. ie: for a list containing Apple, Ball, Cat, and Doug, if you key in 'C'
it would jump to Cat.

Thanks!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
data validation lists [email protected] Excel Discussion (Misc queries) 5 June 25th 05 07:44 PM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM
Data Validation Mike R Excel Discussion (Misc queries) 11 May 6th 05 02:38 AM
Data Validation Window? Ken Excel Discussion (Misc queries) 1 January 11th 05 10:48 PM
Data Validation list selection question Bob Wall Excel Worksheet Functions 2 December 4th 04 04:51 PM


All times are GMT +1. The time now is 06:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"