Just trying to broaden my Excel knowledge and while looking around i noticed you can add Coding to an actual worksheet through the tab at the bottom.

Can you please explain wat this would be used for and please give me some examples of wat you could use this for please.

Thank you