In a project I am developing, I have a need to print a single mailling label from within MS Excel by having the user elect (via a userform) to print either the label or a report. Each user has a supply of blank labels that have 8 rows and 3 columns of peel and stick labels.
My plan, so far, is to create a userform that looks like the layout of the labels sheet with a textbox representing each label. The user will double-click on the label and text from several cells on one of the worksheets will be printed to the selected label position.
Each user could have one of 24 different label positions to print because of any earlier printing.
How can I tell Excel programmatically that I want to print the relevant label (with the cells' values that incidentally come from 6 different cells) onto the said label in the correct position?
Any suggestions will be much appreciated and the end product will be posted here for anybody interested.