Worksheet_BeforeDoubleClick()

J

Jock

There are 5 seperate, non adjacent columns in which I'd like the user to be
able to select any cell and double click it resulting in a tick being placed
in that cell.
I can get it to work for a single column, but can't figure out how to apply
the code to include the other columns.
Piece of the code which I use:
......If Not Application.Intersect(Target, Columns("E:E")) Is Nothing Then.....
I also need columns N, P, S and AB included. Any thoughts?
 
S

Simon Lloyd

Like this:

Code:
--------------------

If Not Intersect(Target, Range("E:E,N:N,P:p,S:S,AB:AB")) Is Nothing Then

--------------------

Jock;328271 said:
There are 5 seperate, non adjacent columns in which I'd like the user to
be
able to select any cell and double click it resulting in a tick being
placed
in that cell.
I can get it to work for a single column, but can't figure out how to
apply
the code to include the other columns.
Piece of the code which I use:
......If Not Application.Intersect(Target, Columns("E:E")) Is Nothing
Then.....
I also need columns N, P, S and AB included. Any thoughts?
Click to expand...


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
 

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

capture date at another sheets using Marlett 1
adding text to comment 8
Get rid of need for F2.Select 3
Insert Row also adds formulas and moves cursor 2
If loop based on logic function 0
Select Case in a Change Event 6
specifying the column for double click 5
Weird behavior on Worksheet_beforedoubleclick event (XL2003) 3

Top