Hello,
I would like to capture data from a userform and transfer it to a worksheet. I have defined all textboxes and comboboxes to the order it should appear on the worksheet.
I have the following formula. However, I would like to execute it without creating the dynamic range or rather the Table. Is there an alternative way of writing this code please?
Your help is much appreciated. I guess what I'm trying to achieve is to transfer the data from the userform to the worksheet in the order in the userform.
Thank you very much
Option Explicit
Dim i As Long
Private Sub Cmd_00_Click()
ReDim arr(0, 36)
With Sheets("Data").ListObjects(1)
.ListRows.Add
For i = 0 To 36
arr(0, i) = Me("CT_" & Format(i, "00")).Value
Next
.DataBodyRange.Cells(.ListRows.Count, 1).Resize(, 37) = arr
End With
End Sub
Bookmarks