+ Reply to Thread
Results 1 to 4 of 4

Link userform cells to worksheet cells

  1. #1
    Forum Contributor
    Join Date
    08-28-2013
    Location
    grand rapids, michigan
    MS-Off Ver
    Excel 2010
    Posts
    163

    Link userform cells to worksheet cells

    I have a user form written in VBA on the Master Sheet (top one). All I need is to get the user form data to populate into the Master Sheet. It seems like it would be easy but I don't even know where to begin.






    NaughtyList 0820.xlsm.

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Link userform cells to worksheet cells

    tel us which fields of the userform in wich fields of the sheet

    kind regards
    Leo

  3. #3
    Forum Contributor
    Join Date
    08-28-2013
    Location
    grand rapids, michigan
    MS-Off Ver
    Excel 2010
    Posts
    163

    Re: Link userform cells to worksheet cells

    Thinking about what you just asked, I realized I just want the exact same fields on the worksheet as are on the form. You can see that the worksheet currently has the tasks individually laid out, but I think it would be just as well if the Field would copy "task 1" into the cell on the worksheet. In the end I would just like to have the individual records stack up forever, but not make the nurses scroll down to find the next blank line. I hope that makes sense. I would like the worksheet reflect an exact copy of the completed user form. If that can be done than I can do the rest.

    Thank you

  4. #4
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Link userform cells to worksheet cells

    perhabs this exemple helps you to see how transfers from userform
    to worksheets go.

    I did not use the master sheet, instead the transfer go to sheet test.


    Kind regards
    Leo
    Attached Files Attached Files

+ 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. [SOLVED] Userform - Run & link to certain cells
    By Harlequin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-21-2012, 08:38 AM
  2. How to link cells by row number from one worksheet to another
    By DerekB in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2009, 11:05 AM
  3. Need to link formatting of cells within the same worksheet
    By Fartnuckles in forum Excel General
    Replies: 5
    Last Post: 10-03-2006, 03:52 AM
  4. Replies: 0
    Last Post: 09-22-2005, 12:05 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