The following questions are about EXCEL VBA:
1. What is a macro? What is the relationship between a macro and a subroutine? What about returning a result from a VB macro?
2. Describe what variables are in a VB and how they are used. List several commonly used VB variable types and provide an example with the Dim statement. (Declare your variables at the beginning of a function or subroutine.)