In VBA, how to assign the value of one array to another?

1. First, select the cell to which you want to allocate the array in the Excel spreadsheet.

2. n. In the interface, click the button options in Insert and Form Control.

3. Generate a button control in the interface version table and modify the name of the control.

4. Next, in the interface, click the "View Code" option.

5. Continue to enter the VBA interface, and enter the statement defining the one-dimensional array.

6. Then, in the VBA interface, enter a statement to assign a weight array to the cell.

7. Finally, in this interface, the cell successfully displays the array allocation results.