• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

vba word help

I have alot of code behind a word app.  I was wondering if there is a way to speed up my document so it don't run slow.

would the screenupdate and screenrefresh work for this situation?
1 Solution
Hi there,

I don't think there's any real way we can help you with this, since we can't see the code to help you optimize it. ScreenUpdate and ScreenRefresh only has to do with when the screen updates or refreshes and wouldn't change the execution speed of your program.

If it's running too slowly, it's probably because you have too many redundant loops or other events that are repeated more than needed. You can also sometimes make logical statements go faster by simplifying them, for example:

If Instr(strName) <> 0 Then

Could just be: If Instr(strName) Then

For some tips on optimizing your code, check out this website:

To be of real help though, we'd have to see the actual code. If you could paste it here, that would be great. If the program is really THAT big though, then maybe you could mail it to one of us to have a look at it, along with a description of what it's supposed to do and why. You can send it to me if you like, at ghandi@mailbox.co.za

Best of luck,
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

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