LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
JB JB is offline
external usenet poster
 
Posts: 115
Default Automatic cell validation prefill by entering first letter

Hi
I have set up a dropdown list validation in a cell. I would like to set it
up so that users can type the first letter of the option they want in the
cell and have it prefill the first option in the list that begins with that
letter. Is this possible?
Thank you for any help you can provide. :)
 
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
New Validation option to format 1st letter as Capital letter Jeff Excel Discussion (Misc queries) 5 July 13th 06 05:11 AM
Automatic scientific format when entering 5E100 Andy Excel Discussion (Misc queries) 3 August 16th 05 01:44 PM
change a cell colour when entering a letter paul42770 New Users to Excel 2 June 27th 05 08:58 PM
How do I convert dollars and cents to text, and prefill the cell . Jan Buckley Excel Worksheet Functions 1 January 20th 05 07:22 PM
letter Validation Maltenrazer Excel Worksheet Functions 0 November 6th 04 12:08 PM


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

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

About Us

"It's about Microsoft Excel"