Excel VBA中,怎么把数据粘贴到窗体答:窗体中要一个文本框,一个命令按钮,两个选项按钮,一个列表框 代码如下:Private Sub CommandButton1_Click()Dim arr(), rng As Rangeendrow = Sheet1.Range("A65536").End(xlUp).Rowcol = IIf(OptionButton1.Value, 2, 1)For Each rng In Sheet1.Range(Cells(1, col), Cells(endrow, col...