ExcelBanter - Dropping A DROPDOWN on set focus

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Dropping A DROPDOWN on set focus (https://www.excelbanter.com/excel-programming/419433-dropping-dropdown-set-focus.html)

Dropping A DROPDOWN on set focus

hi all is this possible ive been searching all night to find out if i can
simply on focus of my msocontroldropdown for it to open up and display the
list after running a macro?

Dropping A DROPDOWN on set focus

Hi,

Try this

Me.ComboBox1.SetFocus
Me.ComboBox1.DropDown

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire

"Rivers" wrote:

hi all is this possible ive been searching all night to find out if i can
simply on focus of my msocontroldropdown for it to open up and display the
list after running a macro?

Dropping A DROPDOWN on set focus

hi shane heres my code bt it says that it does not support this option

Application.CommandBars("saveas").Controls(6).SetF ocus
Application.CommandBars("saveas").Controls(6).Drop Down

"ShaneDevenshire" wrote:

Hi,

Try this

Me.ComboBox1.SetFocus
Me.ComboBox1.DropDown

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire

"Rivers" wrote:

hi all is this possible ive been searching all night to find out if i can
simply on focus of my msocontroldropdown for it to open up and display the
list after running a macro?