Data Validation Select from list

  • I seem to have lost the dropdown list when using data validation.


    Everything else on the validation seems to work. i.e. it is correctly
    not allowing amounts that are not correct.


    I have checked if the correct boxes are ticked on the Data Validation>Settings sheet> both (Ignore Blank and In-Cell Dropdown) and they are ticked.


    Is there anything else I can try.


    Appreciate any help.


    Thanks,
    Rennie

  • hi Rennie,


    your dropdown button may be missing because you have frozen the window?
    i guess some earlier version of XL has this bug.
    if so try to prevent frezzing the window pane or if you really need to distance it away from yr validation list. See if that works

    Cheers
    ___________
    Xlite :sheep:
    [st]All you need to learn VBA is an internet connection and Ozgrid.com[/st]

  • Not necessarily a bug--just a design issue with Excel 97. Not a problem with Excel 2000 and later.

    Barbara - aka The Cat Lady :cat:


    Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us, unless requested by me, will be deleted.

  • oh? could you post the sheet then, for us to take a look?
    if its too big, you can zip it up! :gift:

    Cheers
    ___________
    Xlite :sheep:
    [st]All you need to learn VBA is an internet connection and Ozgrid.com[/st]

Participate now!

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