Datavalidation - dropdown

[Guest]

Is it possible to make a datavalidation with "range"-validation do a dropdown when clicking on the cell, or even to get the F6 key working on cells with datavalidation?

 

[Frank Kabel]

Hi
AFAIK not possible

--
Regards
Frank Kabel
Frankfurt, Germany

Is it possible to make a datavalidation with "range"-validation do a

dropdown when clicking on the cell, or even to get the F6 key working
on cells with datavalidation?

 

[Tom Ogilvy]

Alt+downarrow drops the dropdown

If you click on the cell, then the arrow will appear and you can use that to
dropdown the dropdown. I don't think you can do it on a single click.

Not sure what F6 functionality you want to achieve.

--
Regards,
Tom Ogilvy

Is it possible to make a datavalidation with "range"-validation do a

dropdown when clicking on the cell, or even to get the F6 key working on
cells with datavalidation?

 

[Guest]

Key "F6" is used in many programs, or is perhaps a windows standard, to open/enter dropdownboxes and others
Alt + KeyDown works excelent, thanks )