Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi There,
I want to synchronize two listboxes (I mean having the same topindex for both) on the same form, and unfortunatelly I cannot find any event related to the scrolling, and the other control events are ineffective when the mouse is overthe scrollbar. Has anyone met that problem and found a solution? Thanks, MrT |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I understand that are looking for a scroll related event but would you mind saying a bit more of what you want to do or even post an example of code. Chas "MrT" wrote: Hi There, I want to synchronize two listboxes (I mean having the same topindex for both) on the same form, and unfortunatelly I cannot find any event related to the scrolling, and the other control events are ineffective when the mouse is overthe scrollbar. Has anyone met that problem and found a solution? Thanks, MrT |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
As the list box does not expose the Scroll event, the only way would be to
subclass the control and intercept that message. It appears to be class called "F3 Server 03a80000". I find Excel does not act well with subclassing, so unless you really need to go in that direction, change you approach. Can you not react to the ListBox_Change events ? Otherwise you can fake it with you own scroll bar on frame over the right edge of the list box. Then do what you need in the scroll bar's Scroll/Change event. NickHK "MrT" wrote in message ... Hi There, I want to synchronize two listboxes (I mean having the same topindex for both) on the same form, and unfortunatelly I cannot find any event related to the scrolling, and the other control events are ineffective when the mouse is overthe scrollbar. Has anyone met that problem and found a solution? Thanks, MrT |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can you not react to the ListBox_Change events ?
No, none of the event reacts when you scroll down, as amazing as it might seem. Event the Enter event does not react when you enter via the scroll bar. It looks like the scrollbar is anothercontrol separate from the listbox. Then do what you need in the scroll bar's Scroll/Change event. That's what I've done so far, but it is quite complex to adapt the scrollbar to the listbox. MrT |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You are talking about a combo box, not a list box ?
If a combo box, then yes, the list part is a separate control to the edit part ; the combo box combines them. What are trying to achieve ? NickHK "MrT" wrote in message ... Can you not react to the ListBox_Change events ? No, none of the event reacts when you scroll down, as amazing as it might seem. Event the Enter event does not react when you enter via the scroll bar. It looks like the scrollbar is anothercontrol separate from the listbox. Then do what you need in the scroll bar's Scroll/Change event. That's what I've done so far, but it is quite complex to adapt the scrollbar to the listbox. MrT |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I mean "react to the ListBox_Change event when the user has selected their
choice" NickHK "MrT" wrote in message ... Can you not react to the ListBox_Change events ? No, none of the event reacts when you scroll down, as amazing as it might seem. Event the Enter event does not react when you enter via the scroll bar. It looks like the scrollbar is anothercontrol separate from the listbox. Then do what you need in the scroll bar's Scroll/Change event. That's what I've done so far, but it is quite complex to adapt the scrollbar to the listbox. MrT |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Nick,
Just have a try. Create a ListBox in a form, enter enough rows via the List method so that you have a vertical scrollbar. Then try to detect when you scroll. I can't. MrT "NickHK" wrote: I mean "react to the ListBox_Change event when the user has selected their choice" NickHK "MrT" wrote in message ... Can you not react to the ListBox_Change events ? No, none of the event reacts when you scroll down, as amazing as it might seem. Event the Enter event does not react when you enter via the scroll bar. It looks like the scrollbar is anothercontrol separate from the listbox. Then do what you need in the scroll bar's Scroll/Change event. That's what I've done so far, but it is quite complex to adapt the scrollbar to the listbox. MrT |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I know you don't get the Scroll event .
My question was why do you need to ? NickHK "MrT" wrote in message ... Nick, Just have a try. Create a ListBox in a form, enter enough rows via the List method so that you have a vertical scrollbar. Then try to detect when you scroll. I can't. MrT "NickHK" wrote: I mean "react to the ListBox_Change event when the user has selected their choice" NickHK "MrT" wrote in message ... Can you not react to the ListBox_Change events ? No, none of the event reacts when you scroll down, as amazing as it might seem. Event the Enter event does not react when you enter via the scroll bar. It looks like the scrollbar is anothercontrol separate from the listbox. Then do what you need in the scroll bar's Scroll/Change event. That's what I've done so far, but it is quite complex to adapt the scrollbar to the listbox. MrT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel- smooth scrolling (instead of 'snap' scrolling) | Setting up and Configuration of Excel | |||
Vertical scrolling...jumps rather than smooth scrolling | Excel Discussion (Misc queries) | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta | Excel Discussion (Misc queries) | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel 2003 | Excel Discussion (Misc queries) | |||
Demo of Wheelmouse Scrolling Listboxes | Excel Programming |