I have discovered a strange problem with my VBA code. After testing it on several machines, I've found no problems with my workbook until now. After being run on a rather slow Windows Vista laptop, I've found that VBA appears to be running faster than Excel, and consequently it is creating errors as VBA asks Excel to do things before it has finished a previous action. This is causing macros to fail several times in each run, though can be solved simply by pressing 'debug' and then F5 to continue the code. Is there a way to get VBA to run slower to solve this? As I can't think of any other way of doing it? I've certainly not seen it happen on any XP or Win 7 computer!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Is there a way to slow VBA down??
- Thread starter 450nick
- Start date
govindabairwa
New Member
- Joined
- Apr 11, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
This could be done by inserting wait statement after each line of the main code, but that't not possible so here is the alternative.
Put a wait statement or a loop in the workbook-> SheetChange event
So it will wait for a loop after every change in the sheet , Attached image for example code
To get to this point click on "This Workbook" in Project widow(left side) , then select workbook in the first dropdown and sheetchange in the second dropdown.
Put a wait statement or a loop in the workbook-> SheetChange event
So it will wait for a loop after every change in the sheet , Attached image for example code
To get to this point click on "This Workbook" in Project widow(left side) , then select workbook in the first dropdown and sheetchange in the second dropdown.
Upvote
0
Excel Facts
Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Similar threads
- Question
