Forum Discussion
Form Control Buttons to Take me to a specific areas of a worksheet.
Hello, I'm hoping someone can help. I'm looking to place forms control buttons, that when clicked, will take the viewer to an area of a worksheet. For example: I have a large report that I s...
Application.Goto Sheets("Sheet1").Range("C17")
- Thank you for your reply. I added the code as suggested and when the button is clicked a Run-time error '9': Subscript out of range error is returned.
This works for me, with simple controls and with active X controls.
If the examples in this file do not work for you either, I recommend that you insert a file (without sensitive data).
You could also send this to me as a private message.
Thank you for your response. I've attached a file of one of our branches and excluded account numbers and member names. I've also placed in cells the box sizes (not as buttons, only as text within the cell) for rerferrence as to what buttons I need for this location.