fix cell data entry

[markohl]

right can anyone help as i am drawing a blank on this.

I am creating a reference database which basically allows the end user to scan (using a usb barcode scanner) a barcode into a cell on excel. Once this barcode is entered the sheet then does various look ups to display data.

Basically what i what to do is only allow entry of barcodes into one cell -
So I have locked all other cells so data entry is not possible but at present every time you enter a barcode with the scanner it automatically drops down to the cell below to enter the next number.

Ideally i would like the barcode scanner to keep entering barcodes to the same cell over writting previous scanned barcodes

help!!!

[abousetta]

Hello and welcome to the forum,

How is the barcode data being sent to Excel (e.g. macro)?

This is probably the key but need more details.

abousetta

[markohl]

Hi thanks for the welcome

basically all I have done is plugged in the usb barcoder it then installed its drivers etc. I am not sure how it sends data but now when in excel if you scan anything it pops up in the cell you are on.

I have little knowledge of macros etc

does that help at all?

[abousetta]

Hi,

Well there has to be a way that they are communicating (the scanner and Excel), but if you didn't write the code then its probably using macro somewhere which is locked for viewing.

Back to the drawing board...

My only thought would be to create a worksheet change event macro to replace one cell value with another, but before that, I have a question. You said that it "pops up in the cell you are on". I am assuming that if the cell is already populated then it goes to the cell right below that. Am I correct?

abousetta

[markohl]

no it would just overwrite it with whats scanned and drop to the cell below ready for the next entry - unless locked in which case it just gives the locked message and stays put on the first locked cell it come across