none
help in excel baruch@eimsys.co.il RRS feed

  • Question

  • i ave an barcode reader and i need to read with the barcode reader to cell A1 and automaticly to jump to cell B1 read with barcode reader to cell B1 and automaticly to jump to cell A2 ect. ect.

    because i dont know how to do it and how to write in Macro so i wonder if i could get an excel file with progrming sheet that make this  thing.

    thanks in advanse

    baruch liber

    Friday, November 28, 2014 7:36 AM

All replies

  • Hi baruch,

    >> barcode reader to cell A1 and automaticly to jump to cell B1 read with barcode reader to cell B1 and automaticly to jump to cell A2 ect

    What’s barcode reader that you used? You may need to check its API to read data.

    If the cell will be changed, you could use Worksheet.Change event and in this event, you could select other cell. (Cell(2,1).Select)

    # Worksheet.Change Event (Excel)

    http://msdn.microsoft.com/en-us/library/office/ff839775(v=office.15).aspx

    On the other hand, to get specify cell, you could use Cells property of Worksheet. You could iterate the cells in a loop.

    # Worksheet.Cells Property (Excel)

    http://msdn.microsoft.com/en-us/library/office/ff194567(v=office.15).aspx

    Best Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, December 1, 2014 9:47 AM
    Moderator