I want to populate form values with data if the data chosen in a drop down menu matches with data that is already entered in to the excel sheet. The rest of the values are just textboxes. I was thinking if I could just force the value of the textbox to the data already entered in the sheet, but the form values are not changing. Please help!


Code:
Private Sub wellname_Change()
num = Sheet2.Cells(1, 1) - 1
For Count = 1 To num Step 1
If wellname.Value = Sheet1.Cells(count, 1) Then
UserForm1.point1.Value = Sheet1.Cells(Count, 2)
UserForm1.point2.Value = Sheet1.Cells(Count, 3)
UserForm1.point3.Value = Sheet1.Cells(Count, 4)
UserForm1.point4.Value = Sheet1.Cells(Count, 5)
UserForm1.point5.Value = Sheet1.Cells(Count, 6)
UserForm1.point6.Value = Sheet1.Cells(Count, 7)
UserForm1.point7.Value = Sheet1.Cells(Count, 8)
UserForm1.point8.Value = Sheet1.Cells(Count, 9)
End If
Next Count

End Sub

you need to put .VALUE after everything.

example:
UserForm1.point1.Value = Sheet1.Cells(Count, 2).value

try that. I think that is your problem.

thats right ... you have to know to what are you making refence qhen you put "=", in this case to an atribute of a class, in this case a cell