Datavalidation - dropdown

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Hi
AFAIK not possible

--
Regards
Frank Kabel
Frankfurt, Germany

ALK said:
Is it possible to make a datavalidation with "range"-validation do a
Click to expand...
dropdown when clicking on the cell, or even to get the F6 key working
on cells with datavalidation?
 
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

ALK said:
Is it possible to make a datavalidation with "range"-validation do a
Click to expand...
dropdown when clicking on the cell, or even to get the F6 key working on
cells with datavalidation?
 
Key "F6" is used in many programs, or is perhaps a windows standard, to open/enter dropdownboxes and others
Alt + KeyDown works excelent, thanks :-))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with setting value in validated range 3
Extended DataValidation Dropdown Listbox - Object Creation/Inherit 1
Referencing data validation list in IF Statement 2
Data Validation & Filtering Lists 3
Reg need auto filter excel formulas 1
Guidance required please... 19
data validation on other sheet 5
Determine if a cell has datavalidation 4

Back
Top