It has features for organizing your code, giving you hints about what the functions should look like, and debugging your program while watching it run, step-by-step. Microsoft provides a separate free app to help you write code, the “Visual Basic Code Editor.” You can launch it right from Excel. Automating repetitive tasks is another popular use of VBA. You can also change their properties: sizes, colors, fonts, etc. You can write VBA code to grab parts of Excel (cells, rows, menus, etc.) - and even data from the web - and programmatically change their values. VBA is a programming language built right into Excel and other MS Office applications.

There’s no feature for that in Excel! That’s where Visual Basic for Applications (“VBA”) comes in. What if, for example, you had a worksheet with 20 cities and you wanted to put their current temperatures in each adjacent cell. Sooner or later, every Excel user runs into a problem that can’t be solved with a built-in function or feature.

Visual basic for excel learn