Forum Discussion

Michael1105's avatar
Michael1105
Brass Contributor
Jul 01, 2022

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...
developer
Macros and VBA
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jul 22, 2022
Application.Goto Sheets("Sheet1").Range("C17")
Michael1105's avatar
Michael1105
Brass Contributor
Jul 22, 2022
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.
  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jul 24, 2022

    Michael1105 

    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.

     

     

    • Michael1105's avatar
      Michael1105
      Brass Contributor
      Aug 09, 2022

      NikolinoDE 


      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.

      • NikolinoDE's avatar
        NikolinoDE
        Platinum Contributor
        Aug 09, 2022

        Michael1105 

        Here is your file with the buttons.

        I took the liberty of putting you in different types of buttons (with ActiveX control, without, hyperlink, image) so you can choose what type of button you want to add.

         

        Furthermore, I wish you much success with Excel.

         

        Carpe diem

         

        NikolinoDE

        So di non sapere niente (Socrate)

Resources