A static array is an array, and its subarray size has been determined at the time of declaration, that is, the number of array elements is fixed.

A dynamic array refers to an array whose size is undetermined at the time of declaration, that is, the subscripts in parentheses are ignored. When you want to use it, you can always use the ReDim statement to re-indicate the size of the array. The advantage of using dynamic array is that it can effectively use storage space according to users' needs.