Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi!
I donīt get it although it seemd to be so simple. I want that after I entered a word in column A1 the cursor selects B1 and after that A2 (and so on: B2-A3-B3...) I tried it with this code but there seems to be a problem with the default cursor movement. Who can help? Many thanks Bernd Sub auto_open() Application.OnEntry = "start" End Sub Sub start() If ActiveCell.Column = 1 Then Cells(ActiveCell.Row, ActiveCell.Column + 1).Select Else If ActiveCell.Column = 2 Then Cells(ActiveCell.Row + 1, ActiveCell.Column - 1).Select End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 single cell selecting muliple cell | Excel Worksheet Functions | |||
Selecting a cell entry based on cell validation selection | Excel Worksheet Functions | |||
Transfer cell values to another cell by selecting button. | Excel Worksheet Functions | |||
selecting the next cell down | Excel Discussion (Misc queries) | |||
selecting next available cell | Excel Discussion (Misc queries) |