View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] AshParr@gmail.com is offline
external usenet poster
 
Posts: 13
Default 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