Excel is crashing - vba at fault

[quesakilla]

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.

 

[sijpie]

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)