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

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

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

wrote:

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

--

Dave Peterson