ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i use code39 bar codes that update as a cells value chages (https://www.excelbanter.com/excel-worksheet-functions/136727-how-do-i-use-code39-bar-codes-update-cells-value-chages.html)

Woody

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

Thomas Lutz

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