VBA (Visual Basic for Applications) is the programming language used to create macros. A good knowledge of VBA can save time and make you a much more productive Excel user. VBA is a common programming language found in virtually all Microsoft Office applications. People will often learn VBA before progressing to other languages in due course.
The Excel VBA editor has an Immediate Window that lets you type instructions and test expressions. It will run statements immediately as if you they were run from a procedure.You are also able to precede variables and expressions with a question marl to perform what is operation. For an example, ?Workbooks.Count asks “How many workbooks are open?”. To find the Immediate window you have to go to the View tab and then down to Immediate Window and it will appear at the bottom of the VBA editor. An Example of what you could write in here is Workbooks.Add and this will open a whole new workbook.