[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 295
  • Last Modified:

excel vba code - explaination

Hi,

Mostly when we see the programs we the following two lines at the start of e.g a sub,
application.displayalerts = false
application.screenupdating = false

Now I understand that 'displayalerts' = false would cut any display messages
and 'screenupdating' = false means no processing is shown on the screen
does means the cmd window would not be shown? which appears when vba is processing
I an new to VBA and just trying to clear out my logics
It would great if any one could provide me with explanation on it

Thanks
0
SameerMirza
Asked:
SameerMirza
  • 3
  • 2
1 Solution
 
Rory ArchibaldCommented:
I don't know what you mean by cmd window - I assume you are not talking about a Command window since that has nothing to do with VBA.
0
 
SameerMirzaAuthor Commented:
ok :)
thats why I am here trying to confirm what it actually doesn/ prevents from appearing on the screen
0
 
Rory ArchibaldCommented:
It simply prevents Excel from redrawing the active window so that you don't see cells being updated for example, or switching between worksheets.
0
 
SameerMirzaAuthor Commented:
ok :) thanks alot
I just wanted to be sure - guess a stupid one but it helps
0
 
SameerMirzaAuthor Commented:
thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now