https://ticoneva.com/econ/vba-workshop/
Visual Basic for Application (VBA) is a programming language with an easy to learn syntax. Through VBA one can control many Microsoft applications and even Windows itself. One of its major use is for automating repetitive tasks in Excel. It can also do calculations that are too complicated to manually type out in cells.