I have set up a tiny spreadsheet to print barcodes to an ASCII printer.
To make life simpler for the people that use it, I want to be able to run
the print macro when they press enter in the barcode number cell. What would
be the simplest way of doing this.

The Concrete Hippo

Use the change event.

See Chip Pearson's page for an overview of events:

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"Concrete Hippo" wrote in message
...
I have set up a tiny spreadsheet to print barcodes to an ASCII printer.
To make life simpler for the people that use it, I want to be able to run
the print macro when they press enter in the barcode number cell. What
would
be the simplest way of doing this.

The Concrete Hippo

Thanks,
Very helpful, now to try and put it into practice.


"Tom Ogilvy" wrote:

Use the change event.

See Chip Pearson's page for an overview of events:

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"Concrete Hippo" wrote in message
...
I have set up a tiny spreadsheet to print barcodes to an ASCII printer.
To make life simpler for the people that use it, I want to be able to run
the print macro when they press enter in the barcode number cell. What
would
be the simplest way of doing this.

The Concrete Hippo