ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MouseUp Event (https://www.excelbanter.com/excel-programming/374276-mouseup-event.html)

Paddler

MouseUp Event
 
Scrolling does not in itself generate an event in Excel, Are MouseDown and
MouseUp, which initiate or termainate scrolling, events in Excel that could
trigger an action?
There must be some combination of MouseDown or Up in conjunction with
activate, Target,Row, ActiveWindow.ScrollRow, etc. that could be used to
trigger changing one word in my spreadshhet title block. My Target.Row or
ScrollRow is the one immediatelu below the frozen title block.

NickHK

MouseUp Event
 
If you check the Object Browser, you will there are no events for the Mouse
(or scroll for that matter) that the Application/Worksheet exposes.
If you were to perform the scroll yourself (from a button perhaps), then you
would be in a position to react.

NickHK

"Paddler" wrote in message
...
Scrolling does not in itself generate an event in Excel, Are MouseDown

and
MouseUp, which initiate or termainate scrolling, events in Excel that

could
trigger an action?
There must be some combination of MouseDown or Up in conjunction with
activate, Target,Row, ActiveWindow.ScrollRow, etc. that could be used to
trigger changing one word in my spreadshhet title block. My Target.Row

or
ScrollRow is the one immediatelu below the frozen title block.




Vic Eldridge[_3_]

MouseUp Event
 
The following thread describes a way of responding when a worksheet is
scrolled.

http://groups.google.com/group/micro...df7a833e442766


Regards,
Vic Eldridge


"Paddler" wrote:

Scrolling does not in itself generate an event in Excel, Are MouseDown and
MouseUp, which initiate or termainate scrolling, events in Excel that could
trigger an action?
There must be some combination of MouseDown or Up in conjunction with
activate, Target,Row, ActiveWindow.ScrollRow, etc. that could be used to
trigger changing one word in my spreadshhet title block. My Target.Row or
ScrollRow is the one immediatelu below the frozen title block.



All times are GMT +1. The time now is 04:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com