+ Reply to Thread
Results 1 to 3 of 3

Screen update - does not work? Merged cells and border lines are slow to update?

  1. #1
    Registered User
    Join Date
    05-22-2014
    Posts
    37

    Screen update - does not work? Merged cells and border lines are slow to update?

    Hi.
    I have a macro that first run a delete code;
    Please Login or Register  to view this content.
    In the same code, right after the delete code, a have a userform that pops up.
    After userform, I disable the screenupdate, and at the end of the code, I enable screenupdate.

    What happens, is that all the numbers gets deleted before the userform shows up, but the merged cells and border lines are still there when the userform is showing...?
    It's not a big problem, but seems a little unprofessional to me.
    Is there a way to force a screenupdate (or another methode?) so all of the cells and border lines gets deleted and the merged cells gets unmerged ?

    Thanks!

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Screen update - does not work? Merged cells and border lines are slow to update?

    Does it change if you will use this:

    Please Login or Register  to view this content.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Registered User
    Join Date
    05-22-2014
    Posts
    37

    Re: Screen update - does not work? Merged cells and border lines are slow to update?

    Tried that now, but the result was (while the userform is up, and for the calculations after):
    -merged cells gets unmerged (+)
    -cells did not get cleared (-)
    - borderlines did not get cleared (-)

    This is so strange...

    Made it work, but this is weird... here is the code that works...
    Please Login or Register  to view this content.
    just added a few more clear's...
    Last edited by flabb; 03-02-2016 at 03:41 AM.

+ 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. Slow update (how to improve)
    By Stingone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2012, 01:47 PM
  2. [SOLVED] update button on userform does not update all cells in worksheet
    By tutke in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-27-2012, 03:07 AM
  3. [SOLVED] Windows 7 :Slow screen update with Windows 7
    By Robert Woell in forum Microsoft Windows Help
    Replies: 2
    Last Post: 06-29-2012, 06:56 AM
  4. Slow Update Workbook
    By tuckjoseph in forum Excel General
    Replies: 9
    Last Post: 02-05-2010, 03:29 PM
  5. Macro To Update Cells In Work Sheet
    By gaspower in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-17-2008, 04:49 AM
  6. UserForm_Initialize screen update
    By ozmoges in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-16-2008, 08:50 AM
  7. disable update screen?
    By dianahatesboys in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-13-2006, 02:56 PM
  8. [SOLVED] Stop Excel's UPDATE\Don't UPDATE message box from appearing every time I open the work book
    By divya in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2006, 03:25 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