Private Sub newbt2_Click()
'For k = 1 To 4
'UserForm1.Controls("newtb" & k).Text = Sheets(1).Cells(k, 1)
'Next
For Each x In Me.Controls
If x.Name Like "newtb?" Then
k = k + 1
x.Text = Sheets(1).Cells(k, 2)
End If
Next
End Sub
Book2.rar
(18.77 KB, 下载次数: 10)