+ Reply to Thread
Results 1 to 1 of 1

Problem with worksheet display and userforms in Excel 2016

  1. #1
    Registered User
    Join Date
    06-24-2013
    Location
    Maine
    MS-Off Ver
    Excel 2003
    Posts
    1

    Problem with worksheet display and userforms in Excel 2016

    I'm having an issue with a userform that updates the worksheet displayed behind it. I'm able to reproduce the problem with the attached worksheet. In Excel 2010 the code works as expected. In 2016 (and I assume 2013) the worksheet display only updates if the code is stopped in the debugger. In addtion, the userform will take 20-30 seconds to give control back to the user after the code completes and it will then take 5-10 seconds to even tab from field to field on the userform.

    I would appreciate any guidance as to how to make this code work with the newer versions of Excel.

    UserForm1
    Capture.PNG

    UserForm1 Code
    Please Login or Register  to view this content.
    Worksheet
    Capture.PNG

    Macro Code
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. Replies: 20
    Last Post: 10-19-2016, 06:05 AM
  2. Replies: 9
    Last Post: 06-02-2016, 03:19 PM
  3. [SOLVED] problem with filter in excel 2016
    By pongmeister in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-04-2016, 04:13 PM
  4. Problem with nested if in excel 2016
    By araujo3rd in forum Excel General
    Replies: 2
    Last Post: 04-01-2016, 04:50 AM
  5. Help: Problem with Solver in Excel 2016
    By baballan in forum Excel General
    Replies: 0
    Last Post: 02-17-2016, 04:03 AM
  6. Excel 2016 Problem
    By lgchandana in forum Excel General
    Replies: 4
    Last Post: 12-16-2015, 06:07 AM
  7. Why won't Excel 2016 display my custom ribbon?
    By rkjudy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2015, 04:20 PM

Tags for this Thread

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