|
CommandButton1用Add方法加入了一组文本控件,现在想 CommandButton2得到控件组中某个文本框的文本属性,可以吗?
' 添加按钮控件组
Private Sub CommandButton1_Click()
Dim nCtr As MSForms.TextBox
For i = 1 To 3
for j=1 to 5
' 添加按钮控件
Set nCtr = Me.Controls.Add("Forms.textbox.1", "Test" & i,j)
' 设置按钮控件标题和位置
With nCtr
.Text = i
.Move 10+i*80, 10 + (j- 1) * 30, 80, 30
End With
next j
Next i
'获取第2列第3行文本框的文本。
?
Private Sub CommandButton1_Click()
Dim i%, j%, k%
Dim nCtr As MSForms.TextBox
For i = 1 To 3
For j = 1 To 5
' 添加按钮控件
k = k + 1
Set nCtr = Me.Controls.Add("Forms.textbox.1", "Test" & k)
' 设置按钮控件标题和位置
With nCtr
.Text = k
.Move 10 + i * 80, 10 + (j - 1) * 30, 80, 30
End With
Next j
Next i
'获
End Sub
Private Sub CommandButton2_Click()
Dim i%, j%
i = 2: j = 3 '2列 3行
MsgBox Me.Controls("Test" & (i - 1) * 5 + j).Text
End Sub
|
|