Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with a simple macro | Excel Discussion (Misc queries) | |||
maybe it's simple with macro for this one? | Excel Worksheet Functions | |||
Simple macro please | New Users to Excel | |||
Can't get simple macro to run | Excel Worksheet Functions | |||
SIMPLE MACRO!!! | Excel Programming |