Tick a box to create a label

Hi,

I've designed a label for work. I've removed all the sensitive information. Is there a way in which i could have a tick box on a blank sheet so that i can tick it and it would create a label for me complete with formatting and all the relevent colours etc. So all anybody would need to do is add part specific information to it. I've attached a copy so you can get the jist of what i mean...

Thanks in advance...

Administrator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. I have updated it for you this time because you are a new member. --6StringJazzer

Create a sheet named "Labels". Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your "TEMPLATE" sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Double click the cell in the upper left corner of the label you want to copy to the "Labels" sheet.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Intersect(Target, Range("A1,A7,A13,A19,A25,A31,A37")) Is Nothing Then Exit Sub
    Target.Resize(5, 6).Copy Sheets("Label").Range("A1")
End Sub

I think that the suggestion I made in Post #3 should do what you want without a tick box or drop down.

Try the attached file. Click the button on the Labels sheet.

Try the attached file.

You are very welcome.