Data Validation

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    Hi Excel Guru's,


    I am data validation to display a list of values . The problem am facing is .. this list has a lot of names & it becomes difficult to scroll through when i need to search for a particular name.. Is it possible that when I press a key on my keyboard, the name starting with that letter is highlighted in the drop down list.. This is not happening automatically using data validation... Is there a work aorund for this? Please advise ...

    Re: Data Validation


    Try using a ComboBox control from the Control Toolbox toolbar instead of data validation in a cell. I don't think you will find a way of doing it with standard data validation.

    [COLOR="Purple"]Regards,[/COLOR]
    [COLOR="Purple"]Batman.[/COLOR]

    Re: Data Validation


    Thx Batman, the reason I am using data validation is bcoz i need to display these names in around 5000 cells. I guess if there's no other option, i ll have to stick to the combo box control .. Many thanks again.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login