Thread
:
Is there a way to change the active cell by a text box?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
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
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson