Open DropDownList Automatically

		Microsoft Office Forums > Microsoft Word > Word VBA
Open DropDownList Automatically

FAQ

Mark Forums Read

Thread Tools

Display Modes

04-02-2016, 04:39 AM

highrise955 highrise955 is offline

Windows 10 Open DropDownList Automatically

Office 2013

Advanced Beginner

Join Date: Mar 2016

Posts: 37

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.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can a Folder be set to automatically open all the Files within it?	Roughdiamond	Windows	1	03-12-2016 12:50 AM
Dropdownlist-Parsing values to various ContentControls	highrise955	Word VBA	9	03-08-2016 02:03 AM
Attachments do not open automatically in Outlook 2016	417144	Outlook	0	01-10-2016 12:32 PM
VBA ppt ComboBox behaivor: 1.OnFocus change value 2. get dropdownlist doesn't disappear after mousec	janism22	PowerPoint	2	03-26-2015 12:35 AM
Sending open mails automatically	Fackouch	Outlook	0	05-03-2012 10:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:45 PM.