Nice dave as always. Thanks all.
I end up adding a filter to the front end of the macro. The macro only
runs now when the list index number is changed. This filters out the
triggering of the macro by the scrollbar.

If Range("AH10").Value = .ListIndex Then ' old value at Range
("AH10").Value
Exit Sub
End If

On Jan 7, 1:32*pm, Dave Peterson wrote:
If you're going to use a listbox from the Forms toolbar, I wouldn't assign a
macro to it.

Instead, I'd add a button from the Forms toolbar right near that listbox. *Then
let the user do what they want with the listbox and when they're ready, they can
click on the button (that has the macro assigned to it).

Fan924 wrote:

I have a listbox with a macro assigned. Macro activates when I click
on a different row in the listbox.
It also activates the macro when i scroll up and down. This is
undesirable. Can i turn this off while scrolling.

--

Dave Peterson