In Excel how do i get the cursor to tab down without the keyboard

[DHeckler]

I use a barcode scanner to make entries into an Excel spreadsheet. How do I
get the cursor to move down a column after a scan?

 

[Rick Rothstein]

"down a column"?

Try either ActiveCell.Offset(1,0) or ActiveCell(0,1) depending on if you
meant move down a row or across a column.

 

[pub]

I use a barcode scanner to make entries into an Excel spreadsheet. How
do I get the cursor to move down a column after a scan?

if you are just scanning in. i would try to protect the cells
- highlight your column
- right click on your highlight
- click format cells...
- click the protection tab
- uncheck the locked button
then protect the worksheet depending on what version of excel you have
- in excel 2007 protect is in the Review ribbon
- uncheck "select locked cells"
- in excel 2003 its under Tools>protection
dont bother to give it a password...just protect it if you have a bunch of
scanning to do in a row.