Load data from worksheet into Userform

[Nitehawkhp]

I have a column of data in a worksheet and need to load that data into text boxes on a userform.
I have done this in the past, however, I can’t get the code to work in this new situation.

A sample of the worksheet data consists of the following:

[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]Row[/TD]
[TD]Description[/TD]
[TD]Yes/No[/TD]
[TD]Distance[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Vendor[/TD]
[TD] User Response[/TD]
[TD] User Response[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Category[/TD]
[TD] User Response[/TD]
[TD] User Response[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Series[/TD]
[TD] User Response[/TD]
[TD] User Response[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Orientation[/TD]
[TD] User Response[/TD]
[TD] User Response[/TD]
[/TR]
</tbody>[/TABLE]

I need a macro that will transfer the data into Userform

The Description column will be loaded into TextBoxes on a Userform called:

Textbox1
Textbox2
Textbox3
Textbox4

I have used the following code in a different worksheet and it works.

    Dim i As Integer
        Sheets("Players").Select
        Range("C2").Select
        ToCount = Range("G2")
    
        For i = 1 To ToCount
            Controls("Player" & i) = Cells(i + 1, 3)
        Next i

However, when I use it now I get a compile error
Sub or Function not defined

    Dim i As Integer
        Sheets("Data Validation").Select
        ToCount = Range("X1").Value
        
    
        For i = 1 To ToCount
            Controls("Data" & i) = Cells(i + 1, 3)
        Next i

I have changed the sheets name to match the new worksheet and,
range name for the data.

I have looked up controls and tried to figure out what was needed for that command, but
I don't understand.

Thanks for any help you can provide me.

Rod

 

[My Aswer Is This]

And you have this code in a Button on your Useerform.

Why not show me all the code like.

Private Sub CommandButton1_Click()
And you code here
End Sub

 

[My Aswer Is This]

I suspect you do not have the sheet named exactly like this.
Or maybe the sheet is protected

Or Your Textbox does not have that exact name

Everything must be exact.

 

[Fluff]

Which line of code gets highlighted if you click debug?
The 424 error means that one of those textboxes doesn't exist.

 

[Nitehawkhp]

Mystery solved!!

I had the code under the area (I don't know if this is the correct terminology), on the userform it was placed under the "Click" area and not the "Initialize" area.
Once I moved the code to the initalize area it worked perfectly.

Happy to have this mess fixed.

Thank you to all who provided help and ideas to solve this mystery. Sleeping on it and having a fresh look at things allowed me to find the mistake.
Also, I looked at another userform and noticed the error.

Thanks again,

Rod

 

[Fluff]

Glad you sorted it out & thanks for the feedback