Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Active Cell To Change Formula | Excel Discussion (Misc queries) | |||
On a Mac how do I change the border colour of the active cell? | Excel Discussion (Misc queries) | |||
Change Formatting In 'Active' Cell | Excel Discussion (Misc queries) | |||
How do I change color of active cell in Excel | Excel Discussion (Misc queries) | |||
Active / Dynamic Filtered List (changes w/ change in cell value) | Excel Discussion (Misc queries) |