User Form Adding Data to Worksheet

  • Thread starter Thread starter TotallyConfused
  • Start date Start date
T

TotallyConfused

Hi I need help on how to add UserForm Data to worksheet. I have the
following code and it is not working. I used the code from Microsoft
Article. My UserForm consists of a multipage with 4 pages of textboxes and
frames with checkboxes. I also need to know how to add data from checkboxes
to worksheet. For instance some of the frames have several checkboxes that
can either be one choice or several choices. Thank you in advance for any
help you can provide.

Private Sub CommandButton7_Click()
Dim lastRow As Object

Set lastRow = RequestorInfo.Range("a655536").End(x1Up)

lastRow.Offset(1, 0).Value = txtDate.Text
lastRow.Offset(1, 1).Value = txtFNM.Text
lastRow.Offset(1, 2).Value = txtLNM.Text
lastRow.Offset(1, 3).Value = txtemail.Text
lastRow.Offset(1, 4).Value = txtDept.Text

End Sub
 
Back
Top