+ Reply to Thread
Results 1 to 5 of 5

Excel Button to navigate?

Hybrid View

  1. #1
    MasterCoder84
    Guest

    Excel Button to navigate?

    I have created an up, down, and left and right button in my main worksheet. Every time I click lets say down for example, I want the active cell on sheet2 to move down one. I also want that cell number, such as A2 to be displayed in a cell that I have on my sheet one, kind of like a reference, so you know what cell your in. Is this possible? If so, what do I need to do it?

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    You mean something like this?

    Jason
    Attached Files Attached Files

  3. #3
    MasterCoder84
    Guest
    YES! You Rock! Thank you!!!!!!!!!!!!!!!

  4. #4
    MasterCoder84
    Guest
    Hmmm,

    Now my only question is how do I move the buttons where I want it?

  5. #5
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    Glad I could help. You need to enter the design mode for visual basic first. Make sure the Visual Basic toolbar is showing, and click the Design Mode button. You should then be able to move the buttons. Don't forget to click the button again to exit design mode, or the buttons won't work.

    Jason

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1