Selecting an active cell from a textbox value

Question

I am using this code:

Private Sub TextBox12_Change()
    Range("TextBox12.Value").Select
    TextBox3.Value = ActiveCell.Value
End Sub

and TextBox12 is currently being given the cell reference, I then need TextBox3 to show the value of the active cell, any ideas?

`TextBox3.Value = Range(TextBox12.Value).Value`. And also read this: [How to avoid using Select/Active statements](http://stackoverflow.com/questions/10714251/excel-macro-avoiding-using-select) — Dmitry Pavliv, Apr 22 '14 at 13:30

score 0 · Answer 1 · answered Apr 22 '14 at 11:07

Remove " from code ...

On Error GoTo Fine
Range(TextBox12.Value).Select
TextBox3.Value = ActiveCell.Value
Fine:

Add on Error for Error in the Reference Value ... You can use directly:

TextBox3.Value = Range(TextBox12.Value).Value

without selecting the cell.

1 Answers1