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

0 votes
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.
Oct 2, 2022 in Others by Kithuzzz
• 27,940 points
78 views

1 answer to this question.

0 votes

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
answered Oct 3, 2022 by narikkadan
• 51,600 points

Related Questions In Others

0 votes
1 answer

Excel Drop down list using Apache POI

To set a default value, just setCellValue("first_item_value"); she ...READ MORE

answered Nov 11, 2022 in Others by narikkadan
• 51,600 points
80 views
0 votes
1 answer

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel! ...READ MORE

answered Nov 25, 2022 in Others by narikkadan
• 51,600 points
67 views
0 votes
1 answer
0 votes
1 answer

How to apply zoom animation for each element of a list in angular?

Hey @Sid, do check if this link ...READ MORE

answered Jul 30, 2019 in Others by Vardhan
• 13,200 points
686 views
0 votes
1 answer

Navigate Excel Drop-Down List via Keyboard

You are aware of the auto-complete feature ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 51,600 points
95 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
523 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
2,390 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 22,940 points
112 views
0 votes
1 answer
0 votes
1 answer

How to create a drop-down list in Excel?

Making a list of the items you ...READ MORE

answered Oct 9, 2022 in Others by narikkadan
• 51,600 points
125 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP