Simple macro - help please!!
Mick,
Right click on the sheet tab of the sheet that you want this to work on
and copy/paste the following:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
ActiveCell.Offset(1, 0).Select
End Sub
The above will move to the cell below the selected cell on a double
click.
As for moving to the cell below after an edit, try:
Tools/Options/Edit
Check the box "Move Selection After Enter"
and select "Down"
John
Micheal wrote:
Hey,
How would I write a simple VBA macro to carry out the
following:
1 Select a cell
2 Double click it - or edit the contents (without making
any changes however)
3 move to cell directly below
4 Double click etc?
Cheers
Mick
|