ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to detect mouse pressed(down) event for work sheet (https://www.excelbanter.com/excel-programming/323528-how-detect-mouse-pressed-down-event-work-sheet.html)

helpwithXL

how to detect mouse pressed(down) event for work sheet
 
hi all,
i have a typical problem with getting the mouse event.
I want to able to detect both mouse pressed ( left mouse button pressed
-i.e. held down) and mouse released events on my worksheets(in a range
of cells). Is it possible?
so basically , i want to color the cells while the user keeps mouse
button pressed and when the user releases the mouse button, i want to
remove that color. And this should be possible for a range of cells.
According to the infomation I have, work sheet objects only have this
selectionChange event, which fires only when the mouse button (left
click) is released but I want an event where I can detect the mouse
pressed and released both.

thanx in advance for help.
amit



All times are GMT +1. The time now is 06:03 PM.

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