Limiting number of columns

[in10serush]

Ok, so I'm not to savvy with excel, I mean i can make a basic spreadsheet, but thats about it. What I am trying to do is have a set number of columns, so that when I hit tab it automaticaly goes to the first cel in the next row. The reason I want to do this is because my company takes make model and serial numbers and puts them in spreadsheets( obviously ) we use a scanner to do this and it is programmed to automatically tab over once there is an entry. This is all done to limit time on the keyboard and "manually" pressing the tab button. It would be nice to eliminate hitting -enter- -back- -back- -back- -back- or having to point and click. Any help would be awesome Thanks

 

[Jonmo1]

Welcome to the board...

Perhaps you could do something with Sheet protection...

Highlight the entire Sheet (Press ALT + A)
Click Format - Cells - Protection
CHECK "Locked"
Click OK

Now highlight only the cells that will be used for your data entry
Click Format - Cells - Protection
UNCheck "Locked"
Click OK

Now Click tools - protection - protect sheet
CHECK Every Option EXCEPT "Select Locked Cells"
Add a password if you want, it's not needed..
click OK.

Hope that helps...

 

[IvenBach]

You could try putting your information in a list. When you reach the end of your list, in 2003 at least, it puts you on the next row first column of your list. List option is under Data - List. I use lists quite often and works pretty good.

 

[VoG]

Perhaps: right click the worksheet tab and select View Code then paste in.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column > 10 Then Target.Offset(1, -10).Select
End Sub

then close the code window using the X. This will restrict entry to columns A to J.