screen update

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...

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...

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...

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...

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...

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...

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...