VBA Code to Open or Expand a Drop Down List

[RaudelJr]

Hi,

Is there a way to VBA Code to Open or Expand a Drop Down List in Word?

I've been using the following code:

Code: Select all

Sub AutoDropDown()
  SendKeys "%{down}"
End Sub

But I've been reading that SendKeys is discouraged and only as a last resort.
Any other way to achieve the same?

Thank you for your help in advance.

Raudel


EDIT > Attached an image of what I need.

It's a Legacy Dropdown Form Field.
during the form field, the dropdown will be accessed by tab'ing into it or clicking.
the Macro is inserted into the "Run Macro on Entry" field.

[HansV]

I don't think there is another way, and in this situation, SendKeys should work as intended.

[RaudelJr]

I don't think there is another way, and in this situation, SendKeys should work as intended.

Thank you HansV