"Tim Williams" <timjwilliams at gmail dot com skrev i en meddelelse
...
Do you mean enter the current date instead of the read barcode, or enter
the date in a cell next to the barcode entry ?

How do you currently read the barcode? Select a cell and then scan, or
what?

Most posters here (inc. myself) may not be too familiar with barcodes, so
you could provide more details there.

I'm thinking you could use the worksheet_change event, but it depends on
how "general" you want this feature to be (one specific workbook?)


When i am filling out my return.xls - instead of typing Name,date,package
number. I just want to scan the barcodes on a paper i have. The scanner just
works as a USB keyboard (with the limitation i can only type
"123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ-.*$/+%").
When i scan a barcode it enterns the value in the current field in excel

Therefore i need a combination of the above caracters that could give me
static version of the date today.

Since i cant get it out of the box i am open to any ideas on how excel can
convert the caracters above to the date.

Hope that clears thing up a bit


Regards,
Dennis