+ Reply to Thread
Results 1 to 2 of 2

Copy data from userform to multiple worksheets

  1. #1
    Registered User
    Join Date
    03-21-2014
    Location
    Pittsburgh PA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Copy data from userform to multiple worksheets

    All,
    I am a new member and very basic VBA user but getting better each day. I have a userform which loads the data into a worksheet named "Data" which is being used as a database for an event scheduler. I also load a calendar from a worksheet named "Month" so I need the information from the userform "UForm01" added to 2 worksheets.

    The userform adds a series of textboxes to worksheet "Data" in the first open row. I also need certain textboxes from the Userform to be added to another worksheet to populate the calendar.

    See the code below. Thank you for your help in advance.

    Please Login or Register  to view this content.
    Last edited by kx1bn7; 04-25-2014 at 10:05 AM.

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,528

    Re: Copy data from userform to multiple worksheets

    Please read the forum rules. In this case pay special attention to #3.

+ 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. Ssaving data from userform to multiple worksheets.
    By K Mahendra in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-11-2014, 09:11 AM
  2. Copy/Paste Range of Data from Multiple Workbooks/Worksheets to Master Workbook/Worksheets
    By NumberCruncher311 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-19-2013, 08:21 PM
  3. Userform data to multiple worksheets
    By JessFace in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-04-2010, 12:44 PM
  4. UserForm selected data; to edit multiple worksheets(& specific rows)
    By anonfish in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2010, 11:43 PM
  5. [SOLVED] Copy only certain data from multiple worksheets
    By Matt in forum Excel General
    Replies: 0
    Last Post: 02-10-2006, 11:10 AM

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