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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question