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
• 38,010 points
449 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
• 63,700 points

Related Questions In Others

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
• 63,700 points
530 views
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
• 63,700 points
691 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
• 63,700 points
832 views
0 votes
1 answer

Highlighting Unique List of Words in Each Cell of a Selection of Cells - Excel VBA

In a Textbox it is a vbcrlf ...READ MORE

answered Jan 12, 2023 in Others by narikkadan
• 63,700 points
342 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
• 63,700 points
351 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
957 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
3,289 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
• 23,260 points
582 views
0 votes
1 answer

Hide contents of drop-down list in Excel with password?

So, 3 versions all relatively similar: Above shown ...READ MORE

answered Feb 3, 2023 in Others by narikkadan
• 63,700 points
435 views
0 votes
1 answer
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