So here's our checkbox toggle button we'll use a similar when the button is pressed we will generate a code so let's set two things first will be maybe we can also set on action oh okay.
Automatically inserts those checkbox click something like this and then get pressed here we can say checkbox this will be the name of the coal pipe it was first and we will just replicate this.
One will suffice but just yeah maybe we'll just get rid of this because the idea is same we don't have to rewrite multiple conditions so on action and then get dressed.
No let's get a callback for this too somewhere here so here you will set the same thing it's call this control is gonna be to control and here by value which we don't have to dressed as.
Bullying here we'll declare one more variable let's call this maybe status something like them and it's gonna be bullying true or false and here it's called to this so this will set.
Write in this fashion if we want to read we will need to have a button to be able to get the status of that so maybe we can just have one more button here I'm sorry there's gonna be the label this.
Button can be five so if you see underline there is some problem if this is true you distract and it is not checked ok let's try.
So it is sacked it is not changed okay so this is how you can read and you can set the value I mean yeah you can update the memory variable as well okay that will be for the checkbox now I'll just.
Quickly demonstrate one last thing for contextual tabs like when you click on a pivot or when you click on the chart only then those tabs are gonna show up like the normal actual tabs from where.
You can you know like add additional controls which can perform certain utilities for those you know features within Excel or other products okay so going back to XML for this I'm just.
Gonna use the one we set up earlier so
In this series I think I don't remember exactly which episode was that okay this is quad quad we have to set start from scratch option to true okay this is the.Contextual I just quickly give a demo so once you select this and then see when you are outside in a normal cell you don't see those tab but when you activate the chart you see chart utility.
Step and then you can add certain controls similarly for pivot table you click on pivot only then you will be able to see the pivot you do this okay it's not here.
In this one but the idea is that okay so let's quickly get the XML for that oh we don't have to retype this cancel this contextual tab till here and then these four pivot utilities and this.
Four chart so let's start off with one of them once you can do a wand and it's the same actually so I'm going back to or XML so here this contextual tab is right under ribbon so I'm gonna go back.
Here before this tab XML tag I'm gonna insert this and then do it here okay now let me get rid of this parity duties and okay that's our neighbor so this will be.
Called short utilities button five exists so I'm gonna change it to 506 this label this action maybe we can call this change chart type something like that this is just a demonstration again.
And change color definition in something and the code one and two is gonna run and this is gonna be the image that will show up okay so we can go ahead and just give it a shot maybe we can just assign.
To run this code when this runs Groupon is giving an error let's exchange it a coupon X so if you are in a normal cell this is not gonna show up so let me just quickly.
Generate a date down and let me add a
Chart so here you can see chart utilities table and once you go here you'll be able to see change color definition there's gonna be like check.It's not checked because we are calling this code no it's gonna say it is okay so this is how you can add contextual tabs and if you go to the blog there will be a list.
Of all the contextual tabs like you can add in this similar fashion you're gonna add and then you already know about this group how to group at the group and then within the group we are adding two.
Buttons so the more groups so before we went up let's quickly take a look these are groups and these are the name of the group the group ID so for example this is the name of tab it's not the label.
And the ID that has to all be unique all this control IDs has to be unique level one two three this is a code the callback that is gonna happen to get the labels automatically group.
Two there is more controls and then here so similarly you know like this dynamic menu for the drop-down which is static and then this dynamic menu this for edit box again all these examples or very.
Close examples will be there in the blog as well you can check it off from there and if you have any questions comment below for now I'm gonna stop this video here I hope you found it useful and.
Informative if so do not forget to leave a like and also share with your friends and colleagues so that we can do more videos with your support okay I thank you so much for watching and you.