screen update

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top