Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
double click and move over
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change syperlink from single click to double click | Excel Worksheet Functions | |||
double click mouse, move to referenced wkbk/cell | Setting up and Configuration of Excel | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
CommandBarButton click vs. double click | Excel Programming | |||
Mouse Over Graph, Capture Information on Click(Double Click) | Excel Programming |