Hello friends,
I have a confusion about the following commands.
When to use those commands?
What is the use/effect of those commands in the code?
Which is the proper place to insert this command in the code?
Please guide me to avoide confusion from my mind positively.
application.ScreenUpdating = False application.EnableEvents = False ... Code ... application.EnableEvents = True application.ScreenUpdating = True
Thanking you in anticipation.
Mukesh
Hi Mukesh,
The Application.ScreenUpdating is used to save time. If Excel needs to show you everything it does it takes longer. If you have VBA routines that are taking a long time, you can set the ScreenUpdating to False and Excel can spend time solving the problem and not showing what is happening on the screen. BTW - I had a routine that was going to take about 23 hours and was cut down to only 6 hours with ScreenUpdating = False.
The Application.EnableEvents is to disable VBA code, that is hidden behind the worksheets from being executed. For example, you might have VBA Event Code that is activated when something on a sheet changes. If the code itself changes something on the sheet, the code will need to run again. In this case you want to turn off the code while you change stuff on the sheet and turn it back on after your code has run.
I hope that helps a little. Look at all the types of Event Triggers and see if it makes more sense.
I like this page to explain events http://www.cpearson.com/excel/Events.aspx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hello MarvinP,
Thank you very much for clearing my confusion. Now my concept is clear when to use the application code.
The link is very good and descriptive to learn vba. I will learn a lot of than my present confusion from it.
Thank you and have a nice day.
Mukesh
Great answer MarvinP.
Two additional items:
1. 'Application.ScreenUpdating = False' sometimes can stop the screen from 'flickering' when several cells are being updated and/or more than one resource (workbook and/or sheet) is being accessed.
2. 'Application.EnableEvents = False' is also useful when accessing another Excel file that has an AutoRun macro (ThisWorkbook has code in Workbook_Open()). The 'False' value INHIBITS the 'Workbook_Open()' routine from running.
Lewis
Hi LJMetzger,
Thank you for adding more information to clear the concept.
Mukesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks