How do I get a drop down list to appear if I click on a cell

The key strokes to drop the list is Alt & Down Arrow

You could use the sendkeys application, it does cause problems with the number lock if you have too many send key commands at a time.

For practice purposes, have the data validation in A1

In the worksheet module, enter this code, then select A1

Please Login or Register  to view this content.

Right click the sheet tab and select view code to get to the worksheet module.
-
-

RightClickTab.jpg