UserForm + CommandButton + TextBox + Return Cell Value

[Alphacsulb]

This is my code:
TextBox1 is where the user puts in a row number. Then the user clicks on the CommandButton.

Textbox2 should then be the value of Cell EO + the row number in TextBox1.

I know I'm missing something I just can't figure out what it is.

Private Sub CommandButton1_Click()
MyRowNumber = TextBox1.Value
TextBox2.Text = Range("EO&MyRowNumber").Value
End Sub

I don't have any other in either Textbox.

 

[meldoc]

Hello

Try.

<font face=Courier New><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> CommandButton1_Click()<br>  MyRowNumber = TextBox1.Value<br>  TextBox2.Text = Range("EO" & MyRowNumber).Value<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[Alphacsulb]

That was it!