View Single Post
 
Old 04-02-2016, 04:39 AM
highrise955 highrise955 is offline Windows 10 Office 2013
Advanced Beginner
 
Join Date: Mar 2016
Posts: 37
highrise955 is on a distinguished road
Default Open DropDownList Automatically

Anyone know how to open a dropdownlist automatically upon receiving focus? I tried using the following code options I found in a Google search...

Code:
Private Sub MethodInspect_GotFocus()
    MethodInspect.Dropdown
End Sub

Private Sub MethodInspect_GotFocus()
    Me.MethodInspect.Dropdown
End Sub

Private Sub MethodInspect_GotFocus()
    SendKeys "%{Down}"
End Sub
...but nothing happens. ("MethodInspect" is the Title of the dropdownlist)

Any help would be appreciated.
Reply With Quote