How to Slow the processing Speed of VBA Code - Mr. Excel

I used Other workbooks, Other Worksheets and multiple formulas and filtrations while the writing of code. How can I slow down the speed of ... Forums What'snew Newposts ExcelArticles MrExcelPublishing Login Register What'snew Search Newposts Searchforums Menu Login Register Installtheapp Install Ifyouwouldliketopost,pleasecheckouttheMrExcelMessageBoardFAQandregisterhere.Ifyouforgotyourpassword,youcanresetyourpassword. Forums QuestionForums ExcelQuestions Youareusinganoutofdatebrowser.Itmaynotdisplaythisorotherwebsitescorrectly.Youshouldupgradeoruseanalternativebrowser. HowtoSlowtheprocessingSpeedofVBACode Threadstarter vikas_newports Startdate Dec5,2020 V vikas_newports BoardRegular Joined May26,2016 Messages 121 OfficeVersion 365 Platform Windows Hello Iamlearningtoomuchfromthisforumandlotofexpertsarehelpingmeandothers Iwroteamacrowhichisworkingfineandspeedily,nowitisthetimetoshowthevideoofworkingtomyboss IobservedthattheScreenSeemsHangorStill IusedOtherworkbooks,OtherWorksheetsandmultipleformulasandfiltrationswhilethewritingofcode HowcanIslowdownthespeedofProcessingorScreenUpdatespeed   ExcelFacts Whydoes9meanSUMinSUBTOTAL? Clickheretorevealanswer ItisbecauseSumisthe9thalphabeticallyinAverage,Count,CountA,Max,Min,Product,StDev.S,StDev.P,Sum,VAR.S,VAR.P. A Anthony47 Well-knownMember Joined Mar29,2006 Messages 2,703 OfficeVersion 3652010 Platform Windows Goodjob,uptonow! Idon'tknowifitwillbesufficienttoslowdownthemacro,probablyyoualsohavetoselecttherightportionoftheworkbookforhavingsomethingthatwillmakeyourbosshappy. Sothesearejustsomeguidelines… 1)Addthisdeclarationontopofthevbamodulewithyourmacro Code: #IfVBA7Then'!!!ONTOPOFTHEVBAMODULE!!!! DeclarePtrSafeSubSleepLib"kernel32"(ByValdwMillisecondsAsLongPtr) #Else DeclareSubSleepLib"kernel32"(ByValdwMillisecondsAsLong) #EndIf Thiswillgiveyoutheabilitytoinsertinyourmacrosome"Sleep"statementsthatwillstopthemacroforaslongasyouneed,inmillisecondsstep Theninyourmacroadda"demomode": Code: DimDemoFlAsBoolean'Initialdeclarevariable 'SettheflagtoFalsefornormalexecutionofthemacro: DemoFl=False'OrTRUE,ifwishtoslowdown Then,addinyourmacroblockslikethisonetoshowanupdatingforashort/longtime;thishastobedoneineverypositionyouwishtostopandshow Code: IfDemoFlThen Workbooks("NameOfWorkbook").Activate'Selecttheworkbooktoshow Sheets("XyZ").Select'Selectthesheettoshow Range("myCell").Select'selecttherangetoshow Application.ScreenUpdating=True' Application.Calculate'updateresults DoEvents Sleep200'<<<200mSec.Usedifferentdelaysaccordingyoursituation 'restorepreviousenvironment Application.ScreenUpdating=False'?? '??? '??? EndIf Bewarethattheseblocks,sincetheyselectspecificsheetsandrange,maybewillaltertheworkingscenariothatthemacroispreparedtodealwith(onlyyouknowhowyourmacroworks),somaybethatafterthe"Sleep"you'llneedtore-settheworkbooks,worksheetsandrangeasneeded Finally,whenyouneedtorunthedemo,setDemoFl=Trueandstartthemacro. WhenDemoFlissettoFalsealltheactivitywithintheaddedblockswillbeignored,soyoudon'tneedtoremovethemfromthemacro. Bye   Youmustloginorregistertoreplyhere. Share: Facebook Twitter Reddit Pinterest Tumblr WhatsApp Email Share Link Excelcontainsover450functions,withmoreaddedeveryyear.That’sahugenumber,sowhereshouldyoustart?Rightherewiththisbundle. Forumstatistics Threads 1,167,297 Messages 5,853,131 Members 431,549 Latestmember NnAa Sharethispage Facebook Twitter Reddit Pinterest Tumblr WhatsApp Email Share Link Forums QuestionForums ExcelQuestions We'vedetectedthatyouareusinganadblocker.WehaveagreatcommunityofpeopleprovidingExcelhelphere,butthehostingcostsareenormous.YoucanhelpkeepthissiterunningbyallowingadsonMrExcel.com.AllowAdsatMrExcelWhichadblockerareyouusing?DisableAdBlockFollowtheseeasystepstodisableAdBlock1)Clickontheiconinthebrowser’stoolbar.2)Clickontheiconinthebrowser’stoolbar.2)Clickonthe"Pauseonthissite"option.GobackDisableAdBlockPlusFollowtheseeasystepstodisableAdBlockPlus1)Clickontheiconinthebrowser’stoolbar.2)Clickonthetoggletodisableitfor"mrexcel.com".GobackDisableuBlockOriginFollowtheseeasystepstodisableuBlockOrigin1)Clickontheiconinthebrowser’stoolbar.2)Clickonthe"Power"button.3)Clickonthe"Refresh"button.GobackDisableuBlockFollowtheseeasystepstodisableuBlock1)Clickontheiconinthebrowser’stoolbar.2)Clickonthe"Power"button.3)Clickonthe"Refresh"button.GobackContinuewithoutadsI'vedisabledmyadblock Top