(Solved) : Part 1 Type Following Code Excel Macro Local Veterinary Clinic Option Explicit Option Base Q41336020 . . .

PART 1. Type the following code into an Excel macro for a local veterinary clinic: Option Explicit Option Base 1 Sub BirdIsThA. How large is this array (how many values could be stored)? B. How many dimensions does this array have? c. What value is a
*****USE VBA EXCEL*****PART 1. Type the following code into an Excel macro for a local veterinary clinic: Option Explicit Option Base 1 Sub BirdIsTheWord() Dim ID As Integer, BigBird (7) As String For ID = 1 To 8 BigBird (ID) = “Bird# ” & ID MsgBox BigBird (ID) Next ID MsgBox BirgBird (8) End Sub A. How large is this array (how many values could be stored)? B. How many dimensions does this array have? c. What value is assigned to BigBird(4) ? D. What value is assigned to BigBird(8)? E. Sketch a table of this array showing the values stored and their index numbers (See Part 2 for an example): Show transcribed image text PART 1. Type the following code into an Excel macro for a local veterinary clinic: Option Explicit Option Base 1 Sub BirdIsTheWord() Dim ID As Integer, BigBird (7) As String For ID = 1 To 8 BigBird (ID) = “Bird# ” & ID MsgBox BigBird (ID) Next ID MsgBox BirgBird (8) End Sub
A. How large is this array (how many values could be stored)? B. How many dimensions does this array have? c. What value is assigned to BigBird(4) ? D. What value is assigned to BigBird(8)? E. Sketch a table of this array showing the values stored and their index numbers (See Part 2 for an example):

Expert Answer


Answer to PART 1. Type the following code into an Excel macro for a local veterinary clinic: Option Explicit Option Base 1 Sub Bir…