I want to run a macro when i press return
 

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

I want to run a macro when i press return
 

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

I want to run a macro when i press return
 

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