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?


--
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

Top