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

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,734
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,130,118
Messages
5,640,215
Members
417,131
Latest member
Seanr19871

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