Use this event in the sheet module
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Target.Offset(0, 1).Select
End Sub
See the help for Offset
--
Regards Ron de Bruin
http://www.rondebruin.nl
"mark kubicki" wrote in message ...
what would be the code to do something when the user double clicks a cell,
and THEN MOVE THE SELECTION TO THE NEXT CELL (left or down...t.b.d.) -as
part of the function
i got the do something on double click
but not the "exit that cell and go somewhere else" part
...(the function gets hung-up in edit mode)
...thanks in advance
-mark