Results 1 to 19 of 19

user form to fill in data into specific cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-06-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    361

    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?
    Attached Files Attached Files
    Last edited by bqheng; 05-20-2014 at 02:24 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. user form to fill in data into specific cells
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-27-2014, 07:57 PM
  2. Fill cells determined by Time Value selection w/user form
    By ShannonHowell in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-12-2012, 09:56 PM
  3. Create User form to pull from equipment list and fill in data
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2009, 02:48 PM
  4. [SOLVED] Using Button on User Form to save Data to specific Cell??
    By DarnTootn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2006, 10:25 AM
  5. Retrieving Data from a worksheet to auto fill a user form
    By mg_sv_r in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2006, 06:15 PM

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