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?