I have a listbox LB and I need to have a sub called when and only when a
line in LB is clicked on.

I am having two problems with LB_Click( ):

1. If I click on the line that is already highlighted, LB_Click is not
called.

2. If my macro changes data in the worksheet from which LB derives its
data then LB_Click( ) is called even though nothing was clicked on.

Is there a way to have a sub that:
will be called EVERY time a line in LB is clicked on
(even in case 1 above)

AND

will not be called UNLESS a line in LB is clicked on
(even in case 2 above)?

Thanks for any help!