Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
shortcut key to move to beginning of new row
I am trying to use a barcode scanner to scan in
inventory items into 3 adjacent columns and then would like to have it automatically go to the beginning of the next row by scanning the barcode for a sequence that would put the cursor at the beginning of the next row for the next 3 inputs. Is there a key sequence that will do that?? Thanks.... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
shortcut key to move to beginning of new row
On Sun, 23 Apr 2006 00:51:19 -0400, "bob engler"
wrote: I am trying to use a barcode scanner to scan in inventory items into 3 adjacent columns and then would like to have it automatically go to the beginning of the next row by scanning the barcode for a sequence that would put the cursor at the beginning of the next row for the next 3 inputs. Is there a key sequence that will do that?? Thanks.... I don't know of a key sequence that will send the cursor both down and then left. CTRL and Left arrow will go to the start of a row. Have you thought of running a Worksheet_Change macro from a barcode sequence, and having the macro move the cursor to the start of the next row when the third column contains the active cell? e.g. Assumes data is entered to columns A:C Private Sub Worksheet_Change(ByVal Target As Range) If ActiveCell.EntireColumn.Address = "$C:$C" Then ActiveCell.Offset(1, -2).Select End If End Sub HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
shortcut key to move to beginning of new row
Try:
<Tab <Tab <Enter -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "bob engler" wrote in message ... I am trying to use a barcode scanner to scan in inventory items into 3 adjacent columns and then would like to have it automatically go to the beginning of the next row by scanning the barcode for a sequence that would put the cursor at the beginning of the next row for the next 3 inputs. Is there a key sequence that will do that?? Thanks.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard Shortcut to move to top of column in worksheet? | Excel Discussion (Misc queries) | |||
Is there a shortcut key to move between sheets in Excel? | Excel Discussion (Misc queries) | |||
Shortcut to move to bottom (last) cell in a column | Excel Discussion (Misc queries) | |||
Shortcut key to move to beginning of a worksheet | Excel Discussion (Misc queries) | |||
is there a shortcut to move from one worksheet to another, in Exc. | Excel Discussion (Misc queries) |