Simple macro - help please!!
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 |
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 |
Simple macro - help please!!
Just Click on the record macro button, give it a name and then do what you
need, then click stop recording. HTH "Micheal" wrote in message ... 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 |
All times are GMT +1. The time now is 05:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com