+ Reply to Thread
Results 1 to 6 of 6

Data validation with alphabet selection

  1. #1
    Registered User
    Join Date
    01-16-2014
    Location
    Oman
    MS-Off Ver
    Excel 2010
    Posts
    51

    Data validation with alphabet selection

    On the list when we are typing the first letter then all the data which is starting with that letter has to appear. In data validation how to do this?

    Regards
    Regina

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Data validation with alphabet selection

    If you already have a list, when you start typing in the next empty row, it will show you the closest word to that start-letter. As you start typing more letters, it will get closer to the word/string you want
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-16-2014
    Location
    Oman
    MS-Off Ver
    Excel 2010
    Posts
    51

    Re: Data validation with alphabet selection

    I have more than 100 of data in the list box. But it is not appearing when typing the first letter and starts that list. I have to scroll down to select. But i wanted to show or go the letter i type

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,424

    Re: Data validation with alphabet selection

    Here is a link to a thread from a couple of years back that may be relevant to your question.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Registered User
    Join Date
    01-16-2014
    Location
    Oman
    MS-Off Ver
    Excel 2010
    Posts
    51

    Re: Data validation with alphabet selection

    Thank you JeteMc. The link was useful and i will use the Data Validation method as it suits my requirement. As i am using any forms hence this method is easy.

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,424

    Re: Data validation with alphabet selection

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 01-14-2018, 11:04 AM
  2. Replies: 3
    Last Post: 06-04-2015, 02:27 PM
  3. Data Validation List Selection
    By gwedel in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-25-2015, 01:39 PM
  4. box width for data validation selection
    By vamedic11 in forum Excel General
    Replies: 1
    Last Post: 12-29-2014, 06:23 PM
  5. Replies: 1
    Last Post: 04-01-2014, 08:10 AM
  6. Data validation (LIST) : Auto-Route when enter Alphabet
    By luvnet18 in forum Excel General
    Replies: 1
    Last Post: 07-19-2013, 01:21 PM
  7. Multiple Selection Data Validation and Placement of Selection.
    By LCS in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-08-2012, 08:48 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1