Is there a way to change the active cell by a text box?

  • Thread starter Thread starter AshParr
  • Start date Start date
A

AshParr

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
 
with Worksheets("Orders Placed")
.activate
.Range(row).select
end with

or with minor error checking...

On error resume next
application.goto worksheets("orders placed").range(row)
if error <> 0 then
beep
error.clear
end if
 
Back
Top