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
Bookmarks