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

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