Populate form from row data
 

Here are a few examples, with formatting:
Private Sub CommandButton2_Click()
Unload UserForm3
Application.Quit
End Sub

Private Sub UserForm_Activate()

TextBox1.Text = Cells(3, 27)
TextBox2.Text = Cells(4, 27)
TextBox3.Text = Format(Cells(5, 27), "##0.00##%")
TextBox4.Text = Cells(6, 27)
TextBox5.Text = Format(Cells(7, 27), "$#,##0.00")
TextBox6.Text = Format(Cells(8, 27), "$#,##0.00")

On Error Resume Next

End Sub

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Kent McPherson" wrote:

I want to create my own form for the data in my spreadsheet because I don't
like the default form that Excel creates. Is it a matter of creating many
textboxes and then somehow "reading" the first row? Any good tutorials on
building a form and populating from the spreadsheet would be helpful. I
googled "populate excel form" but didn't find anything that helped.