double click and move over

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

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" <[email protected]> wrote in message news:[email protected]...
> 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
>
>