Pplication screenupdating false
Screen Updating = True Is there an equivalent in CATIA?I have searched the forum and tried everything to resolve this issue. Select as I heard this can set Screen Updating to True. Discover more of his popular Excel Add-ins, including Mouse To Macro and CF Shapes, at his dedicated Excel Add-ins page.
Like you me too don't know the solution for this Please post a sample workbook with all the code; no pictures please. I want the userform1 to stay static without a bunch of screen flashing, etc.... This is a complete guess - but I think that the progress bar on your userform is forcing screen updating, otherwise you wouldn't see an increase in the progress. This seems to point to where I call the function "Is Numeric". Here is the function: thanks for the suggestions all. Screen Updating = False from the sub Only Numbers() procedure that was being called from the importtag sub routine. Screen Updating across the project to stop when it changed state. the userform is visible and all textboxs, comboboxs, etc on all forms are populated. Screen Updating property is useful when running macros that jump from cell to cell, sheet to sheet, and workbook to workbook. Screen Updating to False stops your screen from flickering (refreshing) as your macro runs.in Line 2 to see what happens when you don’t disable screen updating.