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
On Feb 9, 9:25 am, ashish koul wrote:
> 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:
>
> >> Ash
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
rking window 7
> > office 2010 x64
> > > From: robert.a.cama...@gmail.com
> > > To: excel-macros@googlegroups.com
>
> > > solved it:
> > > I had to add a bit mask (i think thats what its called).
>
> > > This returned true when I clicked on a cel
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 trap a left mouse click. I found lots of uses of
GetAsyncKeyState, however, even something simple is not working.
Private Declare Function GetAsyncKeyState Lib "user32.dll" (ByVal vKey
As Long) As Integer
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If GetAsyn
ed cell is in colums D-K
> and rows 2 through 50
>
> If these tests are met, then you can call the subroutine that changes to the
> data sheet and filters the data based on the Target.Value
>
> let me know if you need further examples.
>
> Paul
>
> _
Hi,
Many time I find code that the argument is an integer. IE checking if
the selected cell is a particular column number:
If (Target.Column = 34)
The trouble is that my sheet layout can change, and 34 becomes 35.
Another example of a formula i use in a sheet:
=COUNTIF(T_AllEmp[JOB ROLE REF ID],[@[
Not Intersect(Range(Target.Address), Range("D2:K50")) Is Nothing) Then
>
> checks to see if the selected cell is in colums D-K
> and rows 2 through 50
>
> If these tests are met, then you can call the subroutine that changes to the
> data sheet and filters the data ba
Hi,
I'm not sure if this is possible, so I thought I would cast a wide
net.
Description: I have an Excel spreadsheet with many sheets of summary
and detail information of employees.
On a summary sheet, I have rows that list job titles and the quantity
of employees with that job title in the adjacen
10 matches
Mail list logo
