screen update

  1. D

    Screen flickering while macros running despite disabled screen updating.

    Hello everyone, I would be grateful for any help with screen flickering. The macros download list of stocks historical price data and inserts them in the corresponding to each stock CSV file in the folder C:\VBA\. Screen updates are disabled. I can't figure out what else could be done. Thanks...
  2. S

    Screen Updating Difficulty - Any Ideas?

    Hello All! I am having a tricky time figuring out why I am still getting a screen update in my VBA when I really do not want it. It will just freak out my users and lead to more questions. I have a toggle box switch in VBA that moves, changes colours and executes a sub based on the position...
  3. S

    UserForm updating most, but not all, very inconsistent

    Hey, so I have a userform which is supposed to update based off of another sheet. The user is given 5 options that update, however only 1,3,4 work while 2,5 do not. I double checked (more like 10x) the file and even copied down the lines that work into where 2 and 5 are located, but no matter...
  4. F

    Worksheet Change - ScreenUpdating

    Hi, I`m using Worksheet_Change to put values in table. I set DisplayAlerts and ScreenUpdating to FALSE. Application.DisplayAlerts = False Application.ScreenUpdating = False If Target.Address = "$D$9" Then For g = 1 To rowdata_lr ...... next g End if...
  5. R

    Passively select cells in other worksheet

    I have written some code that runs about 400 lines of code in one worksheet, then 400 lines of code in another worksheet ("Calendar"), and finishes by returning to the first worksheet. When I run the code, it takes about a second to process. There is a flicker for about a quarter-second where...
  6. D

    ScreenUpdating on Excel Mac

    Hi All, I am using Excel Mac 2011 and it appears to be clearly ignoring the screenupdating command. My Macro opens a new workbook and saves it as something else hundreds of times whilst taking information from another workbook which remains open the entire time. The trouble is, the screen...
  7. R

    Sizing problem with adding buttons

    Hi guys, I've written a macro to add buttons to a sheet of mine. The buttons call up various other macros. The problem I'm having seems to be a screen update. I've set the button size to be greater than the number of characters it contains. However when I run the macro, it first adds the button...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top