Offset not working for current selection

[UsmanBPD]

Please Login or Register  to view this content.

This is my code, when the user scans a barcode the value is added into the spreadsheet, and then I would like it to move right and up if the string is 'START-LOCATION', and left and up if the string is 'END-LOCATION', right now after scanning nothing happens

[JBeaucaire]

So the scanner might enter the two text strings "END-LOCATION" or "START-LOCATION"?

A worksheet_change event in your sheet can watch all cell entries, and when it sees one of those text strings entered it will move the cursor appropriately:

This would go into the Sheet module where you want it happening:

Please Login or Register  to view this content.

[UsmanBPD]

Thank you very much, this helped me greatly.

[JBeaucaire]

If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.