On focus after tabbing of Excel drop down automatically show list for selection

Question

Excel has some drop-down lists for data validation; while I can scroll through them all, I must press Alt + Down Arrow to see the list. Is there a way to have it appear automatically when I focus on the tab?
I want the list to appear when the drop-down menu is focused so I can use the arrow keys and the enter key to select something.
Any additional pointers for drop-down lists and VBA would be greatly appreciated.

Answer 1

Put the following code in the Microsoft Excel Sheet1 Module on the sheet that contains the data validation cell (let's say it's cells A1:C1 on Sheet1) (the module that holds the VBA code that is related to the first sheet)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    On Error GoTo Err1:

    If Target = Range("A1") Then
        Application.SendKeys ("%{UP}")
    End If

    If Target = Range("B1") Then
        Application.SendKeys ("%{UP}")
    End If

    If Target = Range("C1") Then
        Application.SendKeys ("%{UP}")
    End If

Err1:
    'do nothing
End Sub