I'm running a simulation with over 500,000 iterations. I've got screenupdating turned on on, statusBar display is on, and I've activated the status bar to print on the iteration number, but it prints out 6000+ and then stops. Could it be that the software is running faster than the screen can...
I am looking to construct a VBA that unhides specific rows across different sheets in a workbook. I can write separate VBA for each sheet/row combination, but was wondering if I can put them all together instead?
3 sheets need the same rows unhidden that I already have code for:
Sub Test()...
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...
I had an application in 2010 which was working fine. I recently have to migrate my application to 2013.
There was lot of flickering occurred in 2013. So I have used application.screenupdating = false in beginning of my macro and set it back to TRUE during end of my macro.
Though setting of...
I am unable to disable the Application.screenUpdating propery. I've seen this issue referenced in various places but have yet to find a solution. Setting this value to false does not seem to do anything, as the value remains true in the watch window. Also, the screen still udpates...
I thought that setting ScreenUpdating and EnableEvents equal to false while executing code would disable all keyboard and mouse events while code is executing, but I was surprised to see that that was not the case.
I have created a simple example that takes a few seconds to execute. While it...
Hello everyone, I am looking for some insight as to whats going on with my code. I am learning a lot, but its my current issue that driving me bonkers. Im here to ask for some help.
I have created a user form for Excel "print" formatting and would like to give the user an option that would...
Hi All
I’m very new to VBA and have run into a problem while adding some simple “animation” (moving images around the screen) to a system I’m developing.
I have a sub which moves a specified image around the screen, I have tested this and it seems to work fine. However when I call it...
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...
Relates to Excel 2013 only- problem not found in pervious versions of Excel.
' Windows 8.1 V 6.3.9600 Build 9600
' Excel 2013 (15.0.4551.1510) MSO(15.0.4551.1508)32-bit
The simplest way for me to start explaining the problem I am having is the following four line procedure Test().
Sub...
<code>I have a strange problem, forever when I ran my code, the screen flashed. I found this line that turns off the flashing
</code><code>
</code><code>Application.ScreenUpdating = False
That code worked perfectly, the screen no longer flashes, however, if I comment out that line and put in...
Hey guys, I have a macro which copies and paste from one sheet to another.
Here is the code:
Sub ENRL_Bolt()
'Transfer format from ENRL_Bolt to Survey Data
Application.ScreenUpdating = False
Sheets("SurveyData").Select 'Set column height width of the SurveyData sheet...
Is there a way to turn screen updating on & off 2 make the macros run faster??? I've tried 2 make this work & it works OK until I try 2 enable the screen update again I get a debug error!!! Thanx 4 anyones help!!! God Bless!!!
Hi,
When I run the following XML importing code I get a message box saying:
"The specified XML source does not refer to a schema. Excel will create a schema based on the XML source data.
[] In future do not show this message"
I turned off the screen updating because I hoped it would then...
Hi,
I've recently had a problem where whenever i opened a certain workbook it went into AutoRecover Saving and stayed like that until it crashed.
As a workaround i added
Application.AutoRecover.Enabled = False to Workbook_Open
and
Application.AutoRecover.Enabled = True to...
Hi,
Not sure if this is something anyone could help me with...
I have written a fairly large a complex workbook which runs a number of macros when it is opened, in order to set worksheet protection, scroll regions etc.
I make extensive use of "Application.ScreenUpdating=False" to hide this...
I try to run this code with an
Application.Screenupdating = False
But visual basic still considers it true.
Not really sure why.
The screen shot should help.
This may be a bit of a complicated message, but I currently have a macro that pulls in data via XML every 15 secs. I am using the screenupdating = false to stop the updating, but every time my macro runs, at the end, the screen will blink. I need help figuring out a way to get rid of that...
I have created an add-in that will add disclaimers to all powerpoint presentations in a folder for a specific customer. All was working well until I decided to try to animate it. Before it would run in about 2-3 seconds per presentation, but as soon as the commented lines below are uncommented...
In Excel 2002, I'm looking for a way to detect when a user has tried to move off a current sheet and if so trap that event to run code before the user is taken to that next sheet. I've tried using the deactivate event and it seems to display the next sheet before firing the deactivate event...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.