Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox macro scrolling problem
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox macro scrolling problem
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox macro scrolling problem
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. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox macro scrolling problem
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox macro scrolling problem
Im using the listbox off of the Forms toolbal.
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox macro scrolling problem
Im using the listbox off of the Forms toolbar.
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox macro scrolling problem
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox macro scrolling problem
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listbox Scrolling | Excel Programming | |||
Scrolling in a form's listbox | Excel Programming | |||
Want listbox to move when scrolling down spreadsheet | Excel Discussion (Misc queries) | |||
ListBox Scrolling in VBA | Excel Programming | |||
listbox scrolling with mouse | Excel Programming |