Dropping A DROPDOWN on set focus

  • Thread starter Thread starter Rivers
  • Start date Start date
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?
 
Hi,

Try this

Me.ComboBox1.SetFocus
Me.ComboBox1.DropDown

If this helps, please click the Yes button.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multi-column Dropdown combox on a commandbar 3
How to set focus on an ActiveX ListBox 7
Txtbox set focus 7
How can I set focus back or remained on Textbox? 2
Drop Down List Box size too small 1
Can I open a combobox from my code 2
Excel losing focus and non-updating userforms 1
Read Dropdown list from Excel column 51

Back
Top