Is there a way to change the active cell by a text box?
I wonder if you guys could help me out with this little problem. I am
trying to give the user an option to pick a cell.
So for example: The User types in A10 & then clicks a button to
activate the cell address just entered(A10).
Im stuck, so far i have got:
Private Sub RowButton_Click()
row = RowBox.Text
Worksheets("Orders Placed").Range("row").Activate
End Sub
That doesnt work, im still learning so any help would be apreciated
Cheers Ash
|