user form to fill in data into specific cells

Hi, Im new to word macro and would like help on this.

Attached is the word document that needs macro codes. It is a template for printing on 13mm round stickers. What i hope to have is a user form that will help user enter data into specific cells in the table and print onto the sticker. The information to be printed will be like this:

1234
001 - 20uL
RSID

each cell will have slightly different information, so copy and pasting is not going to cut it.
One user will not be able to use up the whole sheet of labels on his own, so the next user will carry on from where he left off. The user form must be able to let the user decide where the information goes, if not it will b a disaster if they printed on the space where the sticker has already been removed.

Hope somebody can help me with this

Oh and another thing, is it possible to have the info on the first row to duplicate itself on the second row, third row info duplicate itself on fourth row etc etc?

Instead of a userform, I'd suggest inputting the raw data into an Excel workbook (one row per sticker) and using a label mailmerge to output the data to the sticker sheet. By varying the number of empty rows in the Excel workbook, you can control where on the sticker sheet the output starts.

Trying to control all this via a userform is far more difficult than using a mailmerge.

From the description in your first post, you'd set up an Excel workbook with three columns, one for each row on the label. Each of these columns would have a header row. I have no idea what the three values in your example represent but you might, for example have headers named 'ID', 'Tag' and 'Code', respectively. Having input the data, you'd save the workbook and start a label mailmerge from Word. For outlines of that process, see:
http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm
http://office.microsoft.com/en-us/wo...101857701.aspx

Next time you want to print some labels, simply re-open the workbook, edit the data (including inserting however many empty rows you need to start the next print at the first unused label), save the workbook, then re-open the same malmerge document you used last time and execute the merge.

Why on earth would you bother with all that work when the user can just as easily have all the '-20ul RSID' etc. data already in the table and just enter the prefix data there and format the unwanted cells with the hidden text format?

Also, why all the bookmarks? You can address the cells directly, via their row/column references? With that, you could reduce your code to:

Please Login or Register  to view this content.

where the userform textbox names are R01C01, R01C03, etc. That will take care of not outputting to empty cells also. Of course, you also need a lot more textboxes on your userform to cater for all the cells on the page - you presently cater for only 1/4 of them.

Try:

Please Login or Register  to view this content.

Note: The userform textboxes need to be named:
R01C01 R01C02 R01C03
R02C01 R02C02 R02C03
R03C01 R03C02 R03C03
etc.

Yes, it matters. With the revised code the userform textboxes need to be named:
R01C01 R01C02 R01C03
R02C01 R02C02 R02C03
R03C01 R03C02 R03C03
etc., not:
R01C01 R01C02 R01C03
R03C01 R03C02 R03C03
R05C01 R05C02 R05C03
etc.

I realise its a pain to have to rename them, but you can avoid renaming half of them by moving rows of textboxes up/down.

Change:
Select Case c - 1 Mod 8 + 1
to:
Select Case (c - 1) Mod 8 + 1

If you reduce the column count on the userform, how will you prevent extra labels being printed on the replicated columns when you don't want them? If you reduce the columns on the userform to 4, the replication means the minimum number of labels you'll get is 6.

Simply copy your 'Execute' button, change it's caption to 'Close' and add another sub to your userform like:

Please Login or Register  to view this content.

Your could add a macrobutton field below the table, coded as: {MACROBUTTON Document_Open Double-Click here to reload form}
You will also need to delete the 'Private' before 'Private Sub Document_Open()'.

Note: The field brace pairs (i.e. '{ }') for the above example are created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message.