Write the VBA code to do the following:

1. Create a 10*10 times tables grid, and store the results in an array. Allow the user to enter in two numbers, e.g. 3 and 5, and return the number stored in corresponding element (in this case, (3,5)) of the array which should be 15.
2. Fill an array with 20 random integers in the range 1 to 100. Print out the array, and then the number of elements whose contents are less than 50.
3. Fill an array with 20 random integers and print out the array. Then search the array to discover whether or not it contains an integer contained in a cell referred to by the range name TestNumber.
4. Fill an array with 20 random integers and print it out. Then loop through the array from one end to the other to find the largest number. Print out both the maximum element of the array and the index (position) of this element.
5. Simulate rolling two dice 10,000 times. Your program should determine the frequency of each occurrence of combined dice values using an array and then print the number of times each outcome occurred.

Please use VBA

1. basically make a 10 * 10 times table and make a function that allows the user to enter in two numbers and it should give you the product

2. create an array with 20 numbers between one and one hundred than print that array out plus how many of those numbers are under 50

3. create an array with 20 random integers than write a function asking if that number is in the array

4. create an array with 20 random integers than make a loop to find the max value in the array

5. create a program that rolls two dice 10,000 times and counts the frequency of each result

all of these should be done in visual basic application in excel