View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default print a static date from a barcode

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?)

Tim


"Dennis Pedersen" wrote in message
...
Hello,
Im creating a very simple track and trace system for use only to my own
packages.

And i need excel to type todays date when it reads a barcode. And the date
needs to be static.

Any ideas on how to do this? - im not the big programmer så im lost :)
As far as i can see it can not be done "out of the box". I cant find any
barcode that could give me CTRL+SHIFT+; (static date).

So im looking for another way of doing it :)


Regards,
Dennis