Results 1 to 9 of 9

Copy List of Userform Data to Worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    05-23-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    79

    Copy List of Userform Data to Worksheet

    Hello,

    Is there an easier way of copying a list of various userform txtbox values to one column in excel? There are many more than what I list below, so aggregating the whole process would be more efficient for me.

    Thanks

    Set ws = ThisWorkbook.Worksheets("saveclose")
    
    ws.Cells(1, 2).Value = Me.txtNAME.Value
    ws.Cells(2, 2).Value = Me.txtPHONE.Value
    ws.Cells(3, 2).Value = Me.txtDATE.Value
    ws.Cells(4, 2).Value = Me.txtMNGR.Value
    ws.Cells(5, 2).Value = Me.cmboSTRAT.Value
    ws.Cells(6, 2).Value = Me.txtFIRM.Value
    ws.Cells(7, 2).Value = Me.txtSTRASSET.Value
    Last edited by gsurge; 08-22-2011 at 10:15 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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