Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Cindy Fisher   on Aug 16 In MS Office Category.

  
Question Answered By: Blaze Fischer   on Aug 16

I am doing something similar to this, but I don't know if it will help
you or not. I'm collecting info in VBA text boxs and putting them at
the bottom of a list. The code is all in one "submit" button:

Private Sub btnSubmit_Click()
' define dims
Dim sData As String
Dim lRowNum As Long
sData = txtName.Text

' Put the data in the worksheet:
If Cells(1, 1).Value = "" Then
lRowNum = 1
Else
lRowNum = ActiveSheet.UsedRange.Rows.Count + 1
End If
Cells(lRowNum, 1).Value = sData

End Sub

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Userform Array to worksheet Or get search suggestion and latest updates.


Tagged: