Get a month of TabletWise Pro for free! Click here to redeem

Workbook Events - Workbook Sheet Calculate event

3 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.18
You save:  د.إ146.92
List Price:  A$200.99
You save:  A$57.43
List Price:  ৳11,866.71
You save:  ৳3,390.73
List Price:  CA$190.20
You save:  CA$54.34
CHF 94.14
List Price:  CHF 131.80
You save:  CHF 37.66
List Price:  kr923.82
You save:  kr263.96
List Price:  €123.99
You save:  €35.42
List Price:  £111.45
You save:  £31.84
List Price:  HK$1,084.93
You save:  HK$310
List Price:  ₹10,477.20
You save:  ₹2,993.70
List Price:  RM598.38
You save:  RM170.98
List Price:  ₦54,246.12
You save:  ₦15,500
List Price:  kr1,324.07
You save:  kr378.33
List Price:  NZ$213.40
You save:  NZ$60.97
List Price:  ₱6,939.32
You save:  ₱1,982.80
List Price:  ₨23,350.33
You save:  ₨6,672
List Price:  S$195.06
You save:  S$55.73
List Price:  ฿4,367.55
You save:  ฿1,247.96
List Price:  ₺959.76
You save:  ₺274.23
List Price:  R2,396.08
You save:  R684.64
Already have an account? Log In


In this video we're going to discuss the workbook sheet calculate event. So the workbook sheet calculate event gets triggered whenever a calculation happens in any sheet on your workbook Okay, any sheet that would have calculations happen on it will trigger this event. However, if you for example, change the value of a cell, but that does not trigger any calculations, this event will not be triggered. Okay. So for example, if you enter your name in a cell, and this does not require any calculations to happen, so there are no other cells that are reading your name from from that cell that you entered your name on, and no calculations are required, then, actually, this event will not be triggered. This event also has a parameter called sh here as an object is a sheet object and it actually refers to the sheet That the calculations happened on.

So let's have an example. For example, I'm just going to write a message box here that says calculations happen in. I'm going to put a space here, and then I'm going to close the double quotes. I'm going to have an ampersand and concatenate on sh dot name. So actually is going to say calculations happened in sheet, whatever the name of the sheet is that the calculations happen on. So actually, let's try for example here and this cheat sheet 28.

I'm just going to try writing my name here. Okay, and this is not triggered the event because no calculations were needed. When I entered my name, even if I enter the number five here, there are no other cells reading from that cell, so no calculations are needed. And this is why the event has not been triggered if I enter equals one plus one. This will trigger a calculation it says calculations happen in ci 28 Okay, so sh actually refers to the sheet that the calculation hoppin on, if you even write equals two, okay? This for a solid is a formula.

And for that Excel will need to do calculations. So this is going to trigger the event. Okay? So actually, as you can see here, this triggered the event, if you enter your name and there is another formula, for example, reading the cell or reading from the cell that you entered your name on, this triggered a calculation. So this actually will make the event got triggered. So that's it, guys for the workbook sheet, calculate event.

I typically don't use it a lot, because this event can actually slow down your workbook because it's going to run a lot if you use it, because pretty much any change that you do anything that you select will trigger some calculations so this would run a lot and would slow down your workbook. So you need to be using it very cautiously. Okay, you need to be careful if you're going to use it and make sure if you're going to use it is the last resort and that you've researched all the other options and that you absolutely need to use it. So thanks guys for watching this video and I'll see you on the next one.

Sign Up