![]() |
how do i use code39 bar codes that update as a cells value chages
I need to be record in a column several numbers these need to be added up
with the sum returned as a code39 barcode, the numbers will be entered and the barcode printed, these numbers will then be deleted and a new lot of numbers added, I need the code39 barcode to automatically update as data is entered. eg 2350 2300 3000 2300 1000 1000 2300 1200 Total displayed as code39 that updates after each entry |
how do i use code39 bar codes that update as a cells value chages
One easy way to do what you want to do is to use a good bar code
ActiveX control like the TAL Bar Code ActiveX control. You can drop an instance of the bar code ActiveX control directly onto your worksheet and then set the "LinkedCell" property of the ActiveX control to point to the cell that contain a formula that adds up all the other numbers. (the LinkedCell property tells the ActiveX control what cell contains the data that you want encoded in the bar code) If you do this, the bar code will automatically update each time you add or edit a number in the list. You can download a demo version of the TAL Bar Code ActiveX control from the following web page. http://www.taltech.com/products/activex_barcodes.html If you need help getting it working you can call TAL Technologies directly for support even while you are working with the demo version of the control. On Tue, 27 Mar 2007 16:53:36 -0700, woody wrote: I need to be record in a column several numbers these need to be added up with the sum returned as a code39 barcode, the numbers will be entered and the barcode printed, these numbers will then be deleted and a new lot of numbers added, I need the code39 barcode to automatically update as data is entered. eg 2350 2300 3000 2300 1000 1000 2300 1200 Total displayed as code39 that updates after each entry |
All times are GMT +1. The time now is 04:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com