Combo boxes have an Enter event which fires when you first enter it.
Does that work?

Private Sub ComboBox1_Enter()
MsgBox "Entered combo box"
End Sub


--JP

On Mar 12, 7:08*am, wrote:
On 12 Mar, 11:06, "michael.beckinsale"

wrote:
Hi David,

If you use the ComboBox_Change event the macro will only be triggered
whenever the selection is changed.

HTH

Michael

Yes. *I don't want to do that. *I want to trigger the macro BEFORE the
selection is changed. *I.e. *As soon as the user clicks on the drop
down box.