Q4

Solution using Excel's VBA ( Visual Basic )

please show the code and the worksheet with details.

Q4. Write the VBA code for the program that do the following: (25 Points) 1. Create new module, name is as LastAssignmentQ4 (2 Points) 2. Create new sub name LastAssignmentQ4Sub (2 Points) 3. Create an array to store The Biggest Car Manufacturers. (3 Points) 4. Populate the array with the following data (10 Points) a. Set Volkswagen Group to be in index 1 b. Set Toyota Motor to be in index 2 c. Set Daimler to be in index 3 d. Set Ford Motor to be in index 4 e. Set General Motors to be in index 5 5. Loop through the created array, and while looping write the array elements in the range H1:H5, remember to use offset. (8 Points)