另外 如果想刪除透過程式碼生成的控制項(像是Label)又要怎寫呢??
Private Sub CommandButton2_Click()
For j = 0 To 32
For i = 0 To 6
With Controls.Add("Forms.Label.1", "LA" & j + i, True)'請問這行中的 TRUE 是不是指 要顯示的意思?
.Caption = .Name
.Font.Size = 12
.BorderStyle = 1
.ForeColor = &H80000012
.Top = 42 + (j * 14)
.Left = i * 70
.Width = 70
.Height = 16
.TextAlign = 3
end with
next i
next j
=======================================================
另外不知要怎寫迴圈能表現出下方這種情況呢?
Private Sub UserForm_Initialize()
'新增2欄8列
For j = 1 To 2
k = 0
For i = 1 To 10
k = k + 1
With Controls.Add("Forms.Label.1", , True)'不改它NAME 讓它由Label1 -21
.Caption = .Name
.Top = 20 * (i - 1) + 5
.Left = 160 * (j - 1) + 5
.Width = 155
.Height = 18
ComboBox1.AddItem .Name
End With
Next
Next
End Sub