Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro - specific range
Hi, i have a database, and the data begins from "B5". I need to go from cell
to cell with enter, but after "F5" i need the selected cell to be "B6". I need the data to be entered with enter key just from "B" to "F" and to go back to next row from second cell. I need to be able to write something in other cells, but only if i select the cell with my mouse or with the arrow keys. On enter to go from "B" to "F": Ex: A B C..............F G datas datas datas datas datas datas Can this be done? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro - specific range
From Tools|Options in 2003 and in 2007 from Excel Options| 'Advanced' select
the 'direction' as 'Right' under 'After pressing Enter, move selection'. Select the range B2:F10. The active cell will be B2. With the selection start entering values. After F2 the active cell will be B3. If you are really looking for a macro let us know.. If this post helps click Yes --------------- Jacob Skaria "puiuluipui" wrote: Hi, i have a database, and the data begins from "B5". I need to go from cell to cell with enter, but after "F5" i need the selected cell to be "B6". I need the data to be entered with enter key just from "B" to "F" and to go back to next row from second cell. I need to be able to write something in other cells, but only if i select the cell with my mouse or with the arrow keys. On enter to go from "B" to "F": Ex: A B C..............F G datas datas datas datas datas datas Can this be done? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro - specific range
Try the below macro. Right click on the sheet tab. View code. Paste the below
macro.. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 6 Then Cells(Target.Row + 1, "B").Select ElseIf Target.Column 1 And Target.Column < 6 Then Cells(Target.Row, Target.Column + 1).Select End If End Sub If this post helps click Yes --------------- Jacob Skaria "puiuluipui" wrote: Hi, i have a database, and the data begins from "B5". I need to go from cell to cell with enter, but after "F5" i need the selected cell to be "B6". I need the data to be entered with enter key just from "B" to "F" and to go back to next row from second cell. I need to be able to write something in other cells, but only if i select the cell with my mouse or with the arrow keys. On enter to go from "B" to "F": Ex: A B C..............F G datas datas datas datas datas datas Can this be done? Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro - specific range
Hi, both solution are working!
But the macro it's the best! Thanks allot! "Jacob Skaria" wrote: Try the below macro. Right click on the sheet tab. View code. Paste the below macro.. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 6 Then Cells(Target.Row + 1, "B").Select ElseIf Target.Column 1 And Target.Column < 6 Then Cells(Target.Row, Target.Column + 1).Select End If End Sub If this post helps click Yes --------------- Jacob Skaria "puiuluipui" wrote: Hi, i have a database, and the data begins from "B5". I need to go from cell to cell with enter, but after "F5" i need the selected cell to be "B6". I need the data to be entered with enter key just from "B" to "F" and to go back to next row from second cell. I need to be able to write something in other cells, but only if i select the cell with my mouse or with the arrow keys. On enter to go from "B" to "F": Ex: A B C..............F G datas datas datas datas datas datas Can this be done? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
modify a macro to apply to a specific range of cells | Excel Discussion (Misc queries) | |||
Need help - Macro to copy a specific range | Excel Worksheet Functions | |||
Need help - Macro to copy a specific range | Excel Worksheet Functions | |||
Count Specific word in specific range | Excel Worksheet Functions | |||
Count If Specific word in specific range | Excel Discussion (Misc queries) |