Here it is (I used the new google groups )
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.link
Im not using the right mouse.
If you suggest that I use the right mouse, I'd need to disable the
format popup if I am in my target cell. IE
If Target.Count = 1 and Target.Column = 34 and Target.Value > 0 And
(GetAsyncKeyState(vbKeyLButton) = 1 And &H8000) Then
' my logic
End If
On Feb 9, 9:25 am,
r u using right button also
On Wed, Feb 9, 2011 at 7:53 PM, ashish koul wrote:
> can you share your workbook
>
> On Wed, Feb 9, 2011 at 6:57 PM, rcamarda wrote:
>
>> Ashish,
>> 1. Your code worked from your example.
>> 2. in my other tests, I added added the "= 1" I had, and some of my
>> test s
can you share your workbook
On Wed, Feb 9, 2011 at 6:57 PM, rcamarda wrote:
> Ashish,
> 1. Your code worked from your example.
> 2. in my other tests, I added added the "= 1" I had, and some of my
> test sheets worked.
> 3. It didnt work when i put it into my sheet where I needed it,
> GetAsyncK
Ashish,
1. Your code worked from your example.
2. in my other tests, I added added the "= 1" I had, and some of my
test sheets worked.
3. It didnt work when i put it into my sheet where I needed it,
GetAsyncKeyState(vbKeyLButton) = 1 And &H8000 but it didnt work
4. I opened a fresh excel, pasted yo
1 at 2:08 PM, Dave Bonallack
> wrote:
>
>
>
>
>
> > Thanks Ashish,
> > Works great.
> > Regards - Dave.
>
> > ------------------
> > Date: Wed, 9 Feb 2011 10:32:26 +0530
>
> > Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState n
Feb 2011 10:32:26 +0530
>
> Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7
> office 2010 x64
> From: koul.ash...@gmail.com
> To: excel-macros@googlegroups.com
>
> try this
>
> On Wed, Feb 9, 2011 at 10:27 AM, ashish koul wrote:
>
>
>
Thanks Ashish,
Works great.
Regards - Dave.
Date: Wed, 9 Feb 2011 10:32:26 +0530
Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office
2010 x64
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com
try this
On Wed, Feb 9, 2011 at 10:27 AM, ashish koul
in the trapping of a left mouse click, but couldn't
> understand it from your posts. Could you please attach a workbook
> with working code?
> Regards - Dave.
>
> > Date: Tue, 8 Feb 2011 05:14:53 -0800
> > Subject: $$Excel-Macros$$ Re: GetAsyncKeyState not working windo
ssage box.
Regards - Dave
Date: Wed, 9 Feb 2011 09:03:03 +0530
Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office
2010 x64
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com
hi dave,
see if this helps
On Wed, Feb 9, 2011 at 5:52 AM, Dave Bonallac
Hi Rob,
I am interested in the trapping of a left mouse click, but couldn't understand
it from your posts. Could you please attach a workbook with working code?
Regards - Dave.
> Date: Tue, 8 Feb 2011 05:14:53 -0800
> Subject: $$Excel-Macros$$ Re: GetAsyncKeyState not working wind
solved it:
I had to add a bit mask (i think thats what its called).
This returned true when I clicked on a cell:
If CBool(GetAsyncKeyState(1) & 128) Then
MsgBox ("left click trapped")
End If
(1) is the constant for left mouse click
On Feb 7, 11:28 am, rcamarda wrote:
> Hi,
> I am trying to
12 matches
Mail list logo
