+ Reply to Thread
Results 1 to 3 of 3

When I choose a checkbox it correctly sorts page, but jumps down the page for no reason

  1. #1
    Registered User
    Join Date
    10-22-2014
    Location
    Manchester, TN
    MS-Off Ver
    2010
    Posts
    2

    When I choose a checkbox it correctly sorts page, but jumps down the page for no reason

    I've created a worksheet that is sortable by checkboxes. It took me forever to find out how to do this and I combined two codes to make it work. The macro code is as follows:
    Please Login or Register  to view this content.
    That's the code for one button, the other buttons list Rear Door options or Sideliners. The code works perfectly, but when a checkbox is chosen it jumps you down the page, sometimes below the list completely. How can I force it to stay at the top of the page?
    Last edited by Leith Ross; 10-22-2014 at 12:53 PM. Reason: Added Code Tags

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: When I choose a checkbox it correctly sorts page, but jumps down the page for no reaso

    The following code moves the focus down the page:
    Please Login or Register  to view this content.
    At the bottom of the Sub you can move the focus back to the top of the page using the following or something similar:
    Please Login or Register  to view this content.
    It is also possible that your code will work properly and not cause the focus to jump if you delete the 'C193' Select line.

    Lewis

  3. #3
    Registered User
    Join Date
    10-22-2014
    Location
    Manchester, TN
    MS-Off Ver
    2010
    Posts
    2

    Re: When I choose a checkbox it correctly sorts page, but jumps down the page for no reaso

    Thank you, sir! The code pointing to C193 must've been leftover code from one of the macros I combined. I took it out and worked perfectly! I was ready to add the code to redirect to A1, but I always prefer simpler, cleaner code to complex for no reason code. Rep'd and thanks again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. The page jumps! (Ugh!)
    By jaafallon in forum Excel General
    Replies: 1
    Last Post: 07-26-2010, 02:39 AM
  2. How can I use Excel VBA to choose and push a button in a web-page?
    By FINAFISKEN in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2009, 10:49 PM
  3. tab key jumps to next page
    By laura@isenbleck in forum Excel General
    Replies: 1
    Last Post: 02-27-2006, 05:25 PM
  4. When I doubleclick in Excel, page jumps down/up.
    By EsaMake in forum Excel General
    Replies: 2
    Last Post: 02-01-2006, 03:10 PM
  5. Replies: 0
    Last Post: 11-16-2005, 08:30 PM

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