Mousedown Macro
 

Hi

I am trying to execute some code that automates a process for me.

What I need to know is how can I get my code to recognise the 'right'
click function of the mouse.

I can do this using a simple sub but I want to incorportate it into the
case statement that I already have (see attachment).

Any help is very much appreciated.


+-------------------------------------------------------------------+
|Filename: Sub.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4833 |
+-------------------------------------------------------------------+

--
mabbutt
------------------------------------------------------------------------
mabbutt's Profile: http://www.excelforum.com/member.php...o&userid=34294
View this thread: http://www.excelforum.com/showthread...hreadid=547440

Mousedown Macro
 

Can I assume that this is either not possible or that no one here knows
the answer??


--
mabbutt
------------------------------------------------------------------------
mabbutt's Profile: http://www.excelforum.com/member.php...o&userid=34294
View this thread: http://www.excelforum.com/showthread...hreadid=547440

Mousedown Macro
 

Mouse button click is NOT a keyboard code. You can't send it via SendKeys

HTH
--
AP

"mabbutt" a écrit
dans le message de news:
...

Can I assume that this is either not possible or that no one here knows
the answer??


--
mabbutt
------------------------------------------------------------------------
mabbutt's Profile:
http://www.excelforum.com/member.php...o&userid=34294
View this thread: http://www.excelforum.com/showthread...hreadid=547440

Mousedown Macro
 

Ok, thank you for taking the time to reply.

Back to the drawing board !!!


--
mabbutt
------------------------------------------------------------------------
mabbutt's Profile: http://www.excelforum.com/member.php...o&userid=34294
View this thread: http://www.excelforum.com/showthread...hreadid=547440