+ Reply to Thread
Results 1 to 13 of 13

Worksheet not scrolling after userform unload

  1. 08-18-2017, 03:44 AM #1
    Endlord
    Endlord is offline
    Registered User
    Join Date
    08-18-2017
    Location
    Cape Town
    MS-Off Ver
    2013
    Posts
    7

    Worksheet not scrolling after userform unload

    Hi guys

    I have the code below running in a case management spreadsheet in early development. The problem is, when the form unloads and shows the sheet on which the info was captured, the sheet does not want to scroll with the mouse wheel. You can however drag the scroll-bar up and down and it works. Or if you click on another sheet and then go back to it, then it scrolls with the mouse. Panes are not frozen. I'm thinking it must be something in the code that I'm missing? Thanks!

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Endlord; 08-18-2017 at 04:27 AM.
    Reply With QuoteRegister To Reply
  2. 08-18-2017, 03:47 AM #2
    bakerman2
    bakerman2 is offline
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Worksheet not scrolling after userform unload

    Deleted since OP complied to Forum Rules.
    Last edited by bakerman2; 08-18-2017 at 04:05 AM.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
    Reply With QuoteRegister To Reply
  3. 08-18-2017, 03:50 AM #3
    Endlord
    Endlord is offline
    Registered User
    Join Date
    08-18-2017
    Location
    Cape Town
    MS-Off Ver
    2013
    Posts
    7

    Re: Worksheet not scrolling after userform unload

    Apologies bakerman, 1st time poster. I rectified, thanks for the pointer.
    Reply With QuoteRegister To Reply
  4. 08-18-2017, 04:03 AM #4
    bakerman2
    bakerman2 is offline
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Worksheet not scrolling after userform unload

    I don't see anything weird in your code that would explain such behaviour.
    The only thing I'd change is this. Instead of all those With...End With

    Please Login or Register  to view this content.
    Is it possible to post the file to test ?
    Reply With QuoteRegister To Reply
  5. 08-18-2017, 04:28 AM #5
    Endlord
    Endlord is offline
    Registered User
    Join Date
    08-18-2017
    Location
    Cape Town
    MS-Off Ver
    2013
    Posts
    7

    Re: Worksheet not scrolling after userform unload

    Thanks Bakerman. I thought of looking for a way to clean that up a bit, I'm still a little green with VBA.
    I attached the file to the original post
    Reply With QuoteRegister To Reply
  6. 08-18-2017, 04:36 AM #6
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Worksheet not scrolling after userform unload

    The file is working fine for me


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  7. 08-18-2017, 04:36 AM #7
    Endlord
    Endlord is offline
    Registered User
    Join Date
    08-18-2017
    Location
    Cape Town
    MS-Off Ver
    2013
    Posts
    7

    Re: Worksheet not scrolling after userform unload

    I also see now you can't save and close while on that sheet (after the unload), but can do so when clicking away and clicking back.
    Reply With QuoteRegister To Reply
  8. 08-18-2017, 04:36 AM #8
    Endlord
    Endlord is offline
    Registered User
    Join Date
    08-18-2017
    Location
    Cape Town
    MS-Off Ver
    2013
    Posts
    7

    Re: Worksheet not scrolling after userform unload

    OMW

    Might it be a settings issue on my side. Any idea where to scratch around?
    Reply With QuoteRegister To Reply
  9. 08-18-2017, 04:38 AM #9
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Worksheet not scrolling after userform unload

    What is your excel version?
    Reply With QuoteRegister To Reply
  10. 08-18-2017, 04:41 AM #10
    Endlord
    Endlord is offline
    Registered User
    Join Date
    08-18-2017
    Location
    Cape Town
    MS-Off Ver
    2013
    Posts
    7

    Re: Worksheet not scrolling after userform unload

    Excel 2013 (15.0.4885.1000)
    Reply With QuoteRegister To Reply
  11. 08-18-2017, 04:48 AM #11
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Worksheet not scrolling after userform unload

    Quote Originally Posted by Endlord View Post
    Excel 2013 (15.0.4885.1000)
    Sorry, I don't have excel 2013 to test your file. But I tested it in 2010 and its working fine.

    I hope someone will surely fix your issue.
    Reply With QuoteRegister To Reply
  12. 08-18-2017, 05:39 AM #12
    Endlord
    Endlord is offline
    Registered User
    Join Date
    08-18-2017
    Location
    Cape Town
    MS-Off Ver
    2013
    Posts
    7

    Re: Worksheet not scrolling after userform unload

    I see that there is scrolling happening, but it's scrolling the "Home" sheet, not the active sheet.
    Reply With QuoteRegister To Reply
  13. 08-18-2017, 06:33 AM #13
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Worksheet not scrolling after userform unload

    It's working fine for me in all sheets
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Command button on userform to unload another userform?
    By VAer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2017, 11:01 AM
  2. [SOLVED] Create A UserForm that tracks points and allows scrolling and use of worksheet
    By ChemistB in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-05-2015, 12:13 PM
  3. The userform doesn't seem to unload although I am using unload me line.
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-25-2014, 11:24 AM
  4. Unload all userform
    By danjim02 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-06-2013, 12:13 PM
  5. [SOLVED] userform will not unload with unload me
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2013, 12:09 PM
  6. [SOLVED] Userform called from another userform textbox - unload problem
    By barryleajo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-27-2013, 01:09 PM
  7. How do you unload only the top UserForm?
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-08-2010, 11:18 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1