Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
mrt mrt is offline
external usenet poster
 
Posts: 70
Default Detecting scrolling in listboxes

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default Detecting scrolling in listboxes

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Detecting scrolling in listboxes

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   Report Post  
Posted to microsoft.public.excel.programming
mrt mrt is offline
external usenet poster
 
Posts: 70
Default Detecting scrolling in listboxes

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Detecting scrolling in listboxes

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Detecting scrolling in listboxes

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   Report Post  
Posted to microsoft.public.excel.programming
mrt mrt is offline
external usenet poster
 
Posts: 70
Default Detecting scrolling in listboxes

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Detecting scrolling in listboxes

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel- smooth scrolling (instead of 'snap' scrolling) scooterbaga Setting up and Configuration of Excel 2 April 24th 08 02:16 PM
Vertical scrolling...jumps rather than smooth scrolling Miller Man Excel Discussion (Misc queries) 2 January 23rd 07 07:11 PM
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta [email protected] Excel Discussion (Misc queries) 2 July 21st 06 01:21 AM
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel 2003 [email protected] Excel Discussion (Misc queries) 0 May 12th 06 03:15 AM
Demo of Wheelmouse Scrolling Listboxes Robin Hammond Excel Programming 0 July 16th 03 03:17 AM


All times are GMT +1. The time now is 10:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"