I don't have anything meaningful to post yet but I have collected enough snippets of code to give it a try, perhaps tomorrow.
One of the VBA code example that I got had the exact same line of code as in your post for determining the next available row. But why do I need to determine the next available row if I want the data to go to one specific cell?
Let's say that I have a financial evaluation workbook and I want the user to begin by entering a few key parameters: the first question on page 1 of the multipage userform could be: "what is your cost of capital, in %?" Say, the answer is 12% and I want that number to inserted in cell B6 of the worksheet called "Discounted Cash Flow." The next page may ask "what is the estimated acquisition price, in k$?" and I want the answer to be inserted in cell A5 of the worksheet named "Amortization," and so forth. One piece of data (always a number) inserted into a single cell.
Wouldn't something like this do?:
Private Sub CommandButton1_Click()
With ActiveWorkbook
.Worksheets("Discounted Cash Flow").Range("b6").Value = Me.TextBox1.Value
.Worksheets("Amortization").Range("a5").Value = Me.TextBox2.Value
End With
End Sub