Click Event - list box

  • Thread starter Thread starter kirkm
  • Start date Start date
K

kirkm

I'm getting the click event firing as soon as a Form & List box open.

Stepping through my code I see the Click event happens immediately
after 'Private Sub List1_Enter()'

Is this an obvious way to avoid this somehow? I only want the click
event occurring after a click. (Which it does as well, but this
initial one stuffs everything up.)

Thanks - Kirk
 
Have you got both Enter and Click events? (ie. 'Private Sub List1_Enter()'
and 'Private Sub List1_Click()'.) Do you really need both?

I am assuming that you are opening the list box with code and if so you
could try putting in the following line of code 'Application.EnableEvents =
False' immediately before opening the list box and then
'Application.EnableEvents = True' Immediately after opening the list box and
see if it suppresses the call to the enter event.

Regards,

OssieMac
 
Back
Top