Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving to a different cell automatically.
Fernando, You can use a worksheet_change event handler to do just this. Right click on the worksheet tab then at the top of the VBA edito window paste: Private Sub Worksheet_Change(ByVal Target As Range) If Target = Range("A1") Then Range("B10").Select End Sub HT -- bhofset ----------------------------------------------------------------------- bhofsetz's Profile: http://www.excelforum.com/member.php...fo&userid=1880 View this thread: http://www.excelforum.com/showthread.php?threadid=38647 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving to a different cell automatically.
thank you i ave tried what you have suggested an not much happens. if i start off with range a1 selected and then hit return to go to a2 nothing happens...i was expecting it to go to b10. Am i doing somthing wrong -- Fernandoalbert ----------------------------------------------------------------------- Fernandoalberte's Profile: http://www.excelforum.com/member.php...fo&userid=2449 View this thread: http://www.excelforum.com/showthread.php?threadid=38647 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving data from one tab to other tab automatically | Excel Worksheet Functions | |||
Automatically moving from one cell to another | Excel Worksheet Functions | |||
Moving automatically from one cell to another | Excel Worksheet Functions | |||
moving cell contents (automatically) | Excel Discussion (Misc queries) | |||
Automatically moving data | Excel Programming |