+ Reply to Thread
Results 1 to 4 of 4

Creating an excel template to fill in the barcodes

  1. #1
    Registered User
    Join Date
    08-21-2014
    Location
    USA
    MS-Off Ver
    Microsoft office 2010
    Posts
    2

    Creating an excel template to fill in the barcodes

    Hello,
    Attached in an image of what I am looking for. It is a table with non-formatted text boxes. I would like to have a template ready as shown in the pic.
    All the user would have to do is type in the number and the barcode will be added.
    Now I know that I will have to download the package for barcodes. But my main issue is to have the template ready.
    The fields are always going to be the same (for example: Part#, PO#, Rel No. and so on)
    Hope I could explain it somewhat to get an idea.
    Thank you in advance!

    1408655618411.jpg

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,308

    Re: Creating an excel template to fill in the barcodes

    take a look at the worksheet....I set it up so that if nothing is in the fields it sets the "bar code" field to blank....yes, you will have to format the barcode with a barcode font....I tested it 3of9 code...
    Attached Files Attached Files
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    08-21-2014
    Location
    USA
    MS-Off Ver
    Microsoft office 2010
    Posts
    2

    Re: Creating an excel template to fill in the barcodes

    Thank you for replying back.
    I can download the barcode font.
    But could you please elaborate as to how you created this worksheet.
    I will have to program the process but I cannot even have myself to do it manually yet :-(

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,308

    Re: Creating an excel template to fill in the barcodes

    Although they don't look like it....everything is in a cell.

    there is a formula in each of the barcode fields just to keep things clean

    the borders are just the outside border setup...

    the barcode cells really just look at the cell above and mimic that into the cell....the formatting is the "magic" part....you must Install the font onto your system....mine was called 3of9.ttf
    I just right clicked and chose install....restarted XL (not sure that is needed) and it picked up the new font...right at the top of the list...

    then I turned off the grid to make it look clean...

    does that help?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Creating barcodes in excel 2007
    By evertjvr in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-26-2014, 12:14 AM
  2. Fill word template from excel -> What would be the best method?
    By d82k in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-20-2013, 04:01 PM
  3. Inventory counting by comparing stock barcodes against master barcodes list
    By jamiemacdonough in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2011, 04:51 PM
  4. [SOLVED] Fill FAX template in Word from Excel VBA
    By Frans Verhaar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2006, 01:45 AM
  5. [SOLVED] How do I fill an Excel template from a file
    By Alejandro J. Formichelli in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-21-2005, 11:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1