View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.