View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
helpwithXL helpwithXL is offline
external usenet poster
 
Posts: 28
Default 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