doubleclick to make cells move to another cell
 

i'm trying to program in excel and have one cell i dble click on go to
another cell. is this possible. There are around sixteen different cells to
choose from.

doubleclick to make cells move to another cell
 

Look at the BeforeDoubleClick event

Right click on the sheet tab and select view code. Something like this:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel
As Boolean)
If not Intersect(Target,"Range("A1:A8","F1:F8")) is nothing then
Target.offset(0,3.Select
End if
End Sub



See Chip Pearson's page on events if you are not familiar

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"rayjay" wrote in message
...
i'm trying to program in excel and have one cell i dble click on go to
another cell. is this possible. There are around sixteen different cells
to
choose from.