在Excel中使用扫描仪和条形码，甚至无法从Excel Guru中找到解决方案。 [英] Using Scanners and Barcoding in Excel , can't find a solution even from a Excel Guru.

问题描述

您好，

我正在尝试获取鼠标图标，以便在扫描后向下移动一列条形码进入程序的单元格。当我扫描条形码时，它会自动转到ROW中的下一个单元格（我希望CELL向下移动一个列）。没有
我需要按下输入，因为扫描后它会自动移动，因此excel中的高级选项似乎没有我需要的选项。所有我正在做的就是扫描，我希望能够扫描条形码文档并继续下面列中的下一个
单元格进行库存，而无需重新校正鼠标图标，这样可以节省大量时间和头痛。

I am trying to get the mouse icon to move down a column after I scan a barcode into the program's cell . When I scan a barcode it automatically goes over to the next cell in the ROW ( I want a CELL to move down a COLUMN ) . There isn't any need for me to press enter either because after scanning it moves over automatically, hence the advanced options in excel doesn't seem to have the option I need. All im doing is scanning , I want to be able to scan a barcode document and go on to the next cell in the column underneath for inventory purposes without needing to re correct the mouse icon, it would save a lot of time and headaches.

谢谢。

推荐答案

您好Johnny Tech Sana，我是b $ b我想知道单元格是否仍处于编辑模式或已被编辑并退出编辑模式？

如果单元格仍处于编辑模式，我认为Office无法帮助您选择下一个单元格，因为Office无法知道您是否要继续编辑当前单元格或编辑下一个单元格细胞。当单元格处于编辑模式并且无法退出编辑
模式时，宏将不会执行。请访问
https://social.msdn.microsoft.com/Forums/en-US/3333e18b-cef3 -4d78-b47a-6916a1b2d84c / excel-edit-mode？forum = isvvba 了解更多信息。

如果单元格已经编辑并退出编辑模式，我想你可以使用宏来捕获此操作，然后强制excel选择当前列中的下一个单元格。

这是代码示例。

Hi Johnny Tech Sana,
I want to know if the cell is still in edit mode or has been edited and exited edit mode?
If the cell is still in edit mode, I think Office could not help you select next cell since Office won't know if you want to continue to edit current cell or edit next cell. Macro would not execute when cells are in edit mode and there is no way to exit edit mode. Please visit https://social.msdn.microsoft.com/Forums/en-US/3333e18b-cef3-4d78-b47a-6916a1b2d84c/excel-edit-mode?forum=isvvba for more information.
If the cell has been edited and exited edit mode, I think you could use a macro to catch this action and then force excel to select next cell in current column.
Here is the code example.

Private Sub Worksheet_Change(ByVal Target As Range)
'After editing a single cell in column A, excel will select next cell in column A
If Not Intersect(Target, ActiveSheet.Columns(1)) Is Nothing _
And Target.Cells.Count = 1 Then
Target.Offset(1, 0).Select
End If
End Sub

使用此代码，您可以使用ALT + F11打开VBE，然后双击要在"项目"窗口中使用此代码的工作表。然后，您可以将代码粘贴到代码编辑器中。请在A栏的单元格中输入数据以测试功能。

最好的问候，

Terry

For using this code, you could use ALT+F11 to open VBE and then double click the sheet where you want to use this code in Project window. Then you could paste the code in to the code editor. Please enter a data in a cell in Column A to test the function.
Best Regards,
Terry

这篇关于在Excel中使用扫描仪和条形码，甚至无法从Excel Guru中找到解决方案。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！