Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Joel,
Too much information in my reply, try one of these... First Tabs rows and second Tabs Colums. Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then ActiveCell.Offset(1, 0).Select End If End Sub Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then ActiveCell.Offset(0, 1).Select End If End Sub HTH Regards Howard "Joel Ganger" <Joel wrote in message ... I use a handheld scanner to read barcodes. How do I make excel automatically tab to the next cell after input. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
Sometimes formuli in workbook don't auto update with auto-recal on | Excel Worksheet Functions | |||
How to AUTO SAVE as opposed to turning on auto recovery: EXCEL | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |