Line Printing

[chadwellp]

I am writing a program used for time tracking a foot race. As runners cross the finish line, the runner's Bib# is entered into a cell and an ENTER button is pressed. The program searches a list of Bib#s and enters the date/timestamp int a cell to the right. I have this working. After writing a date and time to a cell, I need to instantly print the cell containing the Bib# and the cell containing the date/timestamp to a battery operated serial tape printer as a printed backup in case of computer failure. I need to figure out the write commands to make this happen. The data entry is to the right side on the "Participants" worksheet attached. Here is the logic below for the data entry:

Please Login or Register  to view this content.

[davesexcel]

You should remove the worksheets and VBA code that do not pertain to your question in your sample.

[Leith Ross]

Hello chadwellp,

I need to instantly print the cell containing the Bib# and the cell containing the date/timestamp to a battery operated serial tape printer

You don't provide us with any details about this printer other than it is a serial device. Serial devices are not all the same. There are many parameters used by serial devices that control how they communicate. Who makes the printer? What is the make and model?

Another, a probably simpler, option would be to output the data to text file and save it on a flash drive. Configuring a printer is not a easy task. Especially when it may not be included in the Plug-n-Play device list.