Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a certain cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a certain cell
use the sheet's change event:
Right click the sheet tab & select "View Code" Add This: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = 1 Then Target.Offset(1, 0).Select ElseIf Target.Row = 2 Then Target.Offset(-1, 1).Select End If End Sub HTH Patrick Molloy Microsoft Excel MVP -----Original Message----- 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a certain cell
Great!
Many thanks Bernd "Don Guillett" schrieb im Newsbeitrag ... IF I understand what you want, if in col A you want to goto col B and if in col B you want to goto A one cell down. If so Right click on the sheet tabview codeinsert thissave As written it won't work in the 1st 3 rows Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Row 3 And Target.Column = 1 Then ActiveCell.Offset(0, 1).Select If Target.Row 3 And Target.Column = 2 Then ActiveCell.Offset(1, -1).Select End Sub -- Don Guillett SalesAid Software "Bernd" wrote in message y.telekom.at... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a certain cell
Bernd
As an alternative to Macro solution....... Select Columns A and B then FormatCellsProtection uncheck "locked". ToolsProtectionProtect Sheet. Use the TAB key when entering data in A1 to go to B1, A2, B2 etc. Gord Dibben XL2002 On Tue, 25 Nov 2003 14:53:59 +0100, "Bernd" wrote: 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a certain cell
glad to help
-- Don Guillett SalesAid Software "Bernd" wrote in message y.telekom.at... Great! Many thanks Bernd "Don Guillett" schrieb im Newsbeitrag ... IF I understand what you want, if in col A you want to goto col B and if in col B you want to goto A one cell down. If so Right click on the sheet tabview codeinsert thissave As written it won't work in the 1st 3 rows Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Row 3 And Target.Column = 1 Then ActiveCell.Offset(0, 1).Select If Target.Row 3 And Target.Column = 2 Then ActiveCell.Offset(1, -1).Select End Sub -- Don Guillett SalesAid Software "Bernd" wrote in message y.telekom.at... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |