Excel is crashing - vba at fault

quesakilla

New Member
Joined
Mar 29, 2013
Messages
1
Beginner here: In my spreadsheet, I have a formula that calculates a coefficient based on several variables. I have probably 10 or so numbers to input and each one of them will affect the vba formula. When I enter the variables too quickly the sheet crashes - and I think it's because the formula is running over and over quickly and it becomes too much. I don't think I can get the vba much cleaner. My first hope is that there is a way to delay the calculation a bit. Make it so that the calculation will run automatically, but it will only update every 5 or 10 seconds. Does that sound possible. Alternatively, is there any way that I could freeze the calculation unless I press a button telling it to update? If you need any more details please let me know.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,976
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
why don't you post your code? Ican then have a look at it. Efficient code should be blistering fast.

Alternatively you can set calc to manual, or like you say only run the macro if you press a button. But first please post the code her (please use the code formatting by preceding the code with [ code] end ending it with [/code]
(there should be no space between the [ and the word code)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,288
Messages
5,836,430
Members
430,428
Latest member
Deepak Tanwar

We've detected that you are using an adblocker.

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.
Go back
Top