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.

On Jan 7, 3:47*pm, 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.

Not sure which event your using, but try the _Itemclick event for
the control.

rgds,
David

There is an ItemClick Event? I don't see that.

Try the MouseUp or MouseDown Event. This event will fire when you mouse
button is clicked down or release.

Hope this helps! If so, let me know, click "YES" below.
--
Cheers,
Ryan


"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.
.

I tried to duplicate the problem by using different events to trigger the
macro and could not get the same result. I could scroll without triggering
the macro when I used the click, change, key press, key down, mouse down
events. are you sure you are not clicking inside the display window?



"Fan924" wrote in message
...
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.

Im using the listbox off of the Forms toolbal.

Im using the listbox off of the Forms toolbar.

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

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