ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can you jump to a selection in a validation drop-down? (https://www.excelbanter.com/excel-worksheet-functions/35148-how-can-you-jump-selection-validation-drop-down.html)

javervoo

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!

Kassie

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!



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com