+ Reply to Thread
Results 1 to 7 of 7

modify a label sheet to add a border

  1. #1
    Forum Contributor
    Join Date
    07-04-2011
    Location
    London, Ontario
    MS-Off Ver
    Excel 365
    Posts
    119

    modify a label sheet to add a border

    Hi,
    I am trying to modify this existing label sheet which has 30 labels on a page.

    RED WINE VIN ROUGE 13.5% alc./vol.
    Return for Refund where Applicable
    Consigné là où la loi le prescrit
    STERLING VINEYARDS
    CALIFORNIA U.S.A
    PRODUCT OF U.S.A. PRODUIT DES E.-U.
    Contains Sulfites – Contient Des Sulfites

    I am trying to now modify the label sheet to put a border with spacing around the line "Contains Sulfites – Contient Des Sulfites"


    I've attached the sheet which I did manually which took me some time as I have to modify every line and format accordingly so they all align to the existing label. I have around 50 similar labels like this to be modified.
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: modify a label sheet to add a border

    Here is the way I did it, and it did not change the footprint of the original label. I just added a paragraph border around the sulfites notice, and then copied the cell and pasted it back to the others. The whole thing took 20 seconds.
    Attached Files Attached Files
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: modify a label sheet to add a border

    Hi there,

    Here's an Excel-based solution which prints 30 labels per page.

    One routine sets the cell height/width based on your page margins.

    You then create your typical label in Cell A1.

    The second routine copies the contents of Cell A1 (including the 750ml TextBox and the Sulfites TextBox with its border) to all of the other 29 cells on the page.

    The attached workbook uses the following code:

    Please Login or Register  to view this content.

    Hope you find the above useful/interesting.

    Regards,

    Greg M
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    07-04-2011
    Location
    London, Ontario
    MS-Off Ver
    Excel 365
    Posts
    119

    Re: modify a label sheet to add a border

    Thanks Greg, I didn't think of an Excel option which is good, However the Cell adjustment module freezes when I try to access. Also how do I replicate for other labels? do just delete the ones created ("a1") once created to rebuild a different one? I have 50+ more of these modifications to be made.

  5. #5
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: modify a label sheet to add a border

    Hi again,

    Thanks for your reply and also for the Reputation increase - much appreciated

    I'm answering from my phone.

    I'll be away from my computer until Friday next, so I'll try to post something for you at that stage.

    Regards,

    Greg M

  6. #6
    Forum Contributor
    Join Date
    07-04-2011
    Location
    London, Ontario
    MS-Off Ver
    Excel 365
    Posts
    119

    Re: modify a label sheet to add a border

    Quote Originally Posted by Greg M View Post
    Hi again,

    Thanks for your reply and also for the Reputation increase - much appreciated

    I'm answering from my phone.

    I'll be away from my computer until Friday next, so I'll try to post something for you at that stage.

    Regards,

    Greg M
    Thanks so much Greg. let me know what can be done. I'm really trying to get something in place to do the 50+ ones I have left and keep on coming as this will be ongoing..

  7. #7
    Forum Contributor
    Join Date
    07-04-2011
    Location
    London, Ontario
    MS-Off Ver
    Excel 365
    Posts
    119

    Re: modify a label sheet to add a border

    Hi,
    still trying to get this label of the ground. I've decided to go for a generic label which I then just need to add if its a white or red and the alcohol %. with the "contains sulphites in two lines and the border neatly wrapped around with space.when I am duplicating for different ones. but cannot get this fixed up as the formatting never matches up.

    HTML Code: 
    _____________________

+ 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. Apply border to data label
    By Atom in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-07-2017, 08:01 AM
  2. Border line thickness on image or label
    By brewsi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2015, 09:44 AM
  3. With a move label macro, prevent label from moving onto another label
    By SocratesJC in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-09-2014, 12:34 AM
  4. [SOLVED] Conditional Data Label border
    By Jabba69 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 07-21-2014, 09:44 AM
  5. [SOLVED] Help with my VBA Code - Modify Chart Border/Fill for Dashboard
    By joelyyc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-30-2014, 11:33 AM
  6. Extract/making label modify
    By Jhon Mustofa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-21-2014, 05:37 AM
  7. Change label border color at runtime
    By timspier in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2006, 02:53 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