View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Greg Wilson Greg Wilson is offline
external usenet poster
 
Posts: 747
Default Mouse-Over State on Graphic Button

Great contribution Vic !!!

I just checked it out. Looks like it could be the solution for the missing
"Worksheet_ScrollChange" event - i.e. capture the event of scrolling the
worksheet. Example:

Sub TimerProc()
Static ScrRw As Long
With ActiveWindow
If .ScrollRow < ScrRw Then Range("A20") = .ScrollRow
'Note: DON'T CALL A MESSAGE BOX or will freeze !!!
ScrRw = .ScrollRow
End With
End Sub

Do you know if there is a performance problem when it is running with large
projects or other issues?

Regards,
Greg Wilson