Dropping A DROPDOWN on set focus

R

Rivers

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?
 
S

ShaneDevenshire

Hi,

Try this

Me.ComboBox1.SetFocus
Me.ComboBox1.DropDown

If this helps, please click the Yes button.
 
R

Rivers

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

Application.CommandBars("saveas").Controls(6).SetFocus
Application.CommandBars("saveas").Controls(6).DropDown
 
Top