+ Reply to Thread
Results 1 to 7 of 7

Help please: User form not updating on Windows 7 Excel 2016

  1. #1
    Forum Contributor
    Join Date
    03-15-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    w 10, Excel 2016
    Posts
    125

    Help please: User form not updating on Windows 7 Excel 2016

    I have a problem displaying a form. Everything works fine under Excel 2016 with Windows 10 – the code executes and displays the form correctly. When I copy the workbook over to a workstation using Excel 2016 with Windows 7 – I get a blank form being shown.

    Here are the details
    Using this code...


    Please Login or Register  to view this content.
    '

    With this form...

    snip_20170330125917.png
    On windows 10 using Excel 2016
    Produces this output (as it should)
    snip_20170330125641.png

    Using the same code same form on Windows 7 with Excel 2016 produces a blank form like this....


    snip_20170330122558.png

    I've rebooted the workstation (thinking it might be a memory issue) but nothing changed. Is there anything I've missed or configurations I need to check? Any help would be greatly appreciated.

  2. #2
    Registered User
    Join Date
    09-19-2013
    Location
    NY, NY
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Help please: User form not updating on Windows 7 Excel 2016

    Hi,
    I'm just taking a couple of shots in the dark here... I seem to have had a similar problem a While back... memory just doesn't serve me as it used to...
    Look into 64-bit functions on a 32-bit OS/Office... also look into Calculation being set to manual instead of Auto in the Excel Options...
    HTH
    Cheers.

  3. #3
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Help please: User form not updating on Windows 7 Excel 2016

    Hello Andrew Entee,

    Have you tried to set the VBE Tools>References>Microsoft Visual Basic for Applications Extensibility 5.3 as per the image attached?

    Regards.
    Attached Images Attached Images
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Help please: User form not updating on Windows 7 Excel 2016

    Hi,

    Have you tried adding either DoEvents or Userform1.Repaint after showing the form?

    I would personally show the form once at the beginning of the loop and then merely repaint it after updating in each pass through. GoSub is a blast from the past!
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Help please: User form not updating on Windows 7 Excel 2016

    Are you showing the userform multiple times?

    Why don't you show it just once and have code update it as you process?
    If posting code please use code tags, see here.

  6. #6
    Forum Contributor
    Join Date
    03-15-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    w 10, Excel 2016
    Posts
    125

    Re: Help please: User form not updating on Windows 7 Excel 2016

    @Alphonse68, @Winon @xlnitwit @Norie - Thanks so much for you suggestions. I will try these. Not had to use forms before in VBA so I'm new to it. I'll report back on how this was resolved.

    Thanks again

  7. #7
    Forum Contributor
    Join Date
    03-15-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    w 10, Excel 2016
    Posts
    125

    Re: Help please: User form not updating on Windows 7 Excel 2016

    @Alphonse68, @Winon @xlnitwit @Norie - Thanks so much for you suggestions.

    @xlnitwit you were correct. Using the .show outside the loop and .repaint inside the loop fixed the problem. Not sure why the difference from windows 7 to windows 10... but its working now. I'll mark this closed.

    and yes, I'm an old crusty developer - but not developed software for 25 years... so back to learning... hence the use of gosub (which I still find works great by the way!)

    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. VBA User Form Updating Data and dynamic date ranges
    By DaveNUFC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-10-2016, 01:32 PM
  2. [SOLVED] XYChartLabeler add-in & Excel 2016 for Windows
    By Andrew_S in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-07-2016, 12:21 PM
  3. Replies: 4
    Last Post: 03-30-2016, 11:30 AM
  4. Replies: 23
    Last Post: 12-29-2015, 05:02 PM
  5. [SOLVED] Excel vba user form- open directly to user form not worksheet
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 04-24-2013, 05:07 PM
  6. auto open user form at windows logon
    By Ignesh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2012, 03:54 AM
  7. [SOLVED] User Form not updating worksheet
    By denise6372 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-10-2012, 02:47 AM

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