how to detect mouse pressed(down) event for work sheet

H

helpwithXL

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
 

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

Similar Threads

Right-mouse open a 2nd file to a particular sheet that correspondswith a 1st file's sheet 2
sheet event wait for another event? 6
Worksheet Change event - not running when down arrow is pressed 3
how to select contents from a col which lies in between other columns 2
Code to add comments to selected cells within a selected range 30
How to simulate Control (button) and Mouse Selection of cell 0
How to get position of mouse via VB in a worksheet 3
Use mouse to select sheet 3

Top