Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bob engler
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Buttrey
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ragdyer
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keyboard Shortcut to move to top of column in worksheet? piddilin Excel Discussion (Misc queries) 6 April 25th 23 03:43 AM
Is there a shortcut key to move between sheets in Excel? Josh Craig Excel Discussion (Misc queries) 4 May 8th 08 04:36 PM
Shortcut to move to bottom (last) cell in a column Frustrated Excel Discussion (Misc queries) 1 September 21st 05 03:47 AM
Shortcut key to move to beginning of a worksheet Martha Excel Discussion (Misc queries) 1 February 22nd 05 08:53 PM
is there a shortcut to move from one worksheet to another, in Exc. twylagirl Excel Discussion (Misc queries) 2 January 6th 05 08:55 PM


All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"