please see the picture for instructions

make an array(8 inputs)

when you put input(8) for column A it will also display the reverse of the inputs in the column b

Exercise Create a new workbook called 14_MyArray (enabled-macro). Write a VBA macro that declares an array called MyArray of size 8. Input items using the InputBox function. Under the headings 'Array Elements' and 'Array Reverse' the macro should transfer the array to column A in the default worksheet. The program should also write the contents of the array in reverse order to column B of the worksheet. (Hint: to write the contents in reverse use For num-8 To 1 step -1)