Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving automatically from one cell to another
Hi, I would like to know if there is a function that enables the automatic movement from one cell to another. For example, i have a function in B1 that works on the value of A1. After inserting the value in A1, I want to move automatically from A1 to C1 or to any other cell. Thanks for your assistance. Regards Stefan -- sfar007 ------------------------------------------------------------------------ sfar007's Profile: http://www.excelforum.com/member.php...o&userid=35131 View this thread: http://www.excelforum.com/showthread...hreadid=549657 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving automatically from one cell to another
Try this, it isn't perfect... Sub auto_open() ThisWorkbook.Worksheets("Sheet1").OnEntry = "DidCellsChange" End Sub Sub DidCellsChange() Dim KeyCells As String KeyCells = "A1" If Not Application.Intersect(ActiveCell, Range(KeyCells)) _ Is Nothing Then KeyCellsChanged End Sub Sub KeyCellsChanged() Range("C1").Select End Sub -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=549657 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving automatically from one cell to another
The problem with that macro is that it selects the cell before the Enter or Tab, so it actually go to 1 offset of the cell you want them to go (in this case, if they tab, it goes to D1, if they Enter, it goes to C2). Perhaps someone can shred some light on it -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=549657 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving automatically from one cell to another
Put in sheet's kodewindow
Private Sub Worksheet_Change(ByVal Target As Range) If ActiveCell = Range("a2") Then ActiveCell.Offset(-1, 2).Select End Sub |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving automatically from one cell to another
Nice and clean, Nice =) -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=549657 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving automatically from one cell to another
thanks for your help Stefan -- sfar007 ------------------------------------------------------------------------ sfar007's Profile: http://www.excelforum.com/member.php...o&userid=35131 View this thread: http://www.excelforum.com/showthread...hreadid=549657 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow Moving From Cell to Cell | Excel Discussion (Misc queries) | |||
Row Expansion | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Edit cell automatically takes you to cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |