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

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.)