Private Sub Command1_Click() Dim a As Control For Each a In Me.Controls a.Enabled = False'历遍窗体中所有控件,将所有控件的Enabled 设置为False Next Command1.Enabled = True'最后将你想要设置为True的控件设置为True就可以了 End Sub
加上一句: On Error Resume Next 忽略就行了!Private Sub Command1_Click() Dim a As Control '************* On Error Resume Next '************* For Each a In Me.Controls a.Enabled = False Next Command1.Enabled = End Sub
或者使用TypeName函数判断控件的类型,再设置属性也可以Private Sub Command1_Click() Dim a As Control For Each a In Me.Controls If TypeName(a) = "CommandButton" Then a.Enable=False End If Next
Dim a As Control
For Each a In Me.Controls
a.Enabled = False'历遍窗体中所有控件,将所有控件的Enabled 设置为False
Next
Command1.Enabled = True'最后将你想要设置为True的控件设置为True就可以了
End Sub
这方法很好,很好理解,用起来也很简单
On Error Resume Next
忽略就行了!Private Sub Command1_Click()
Dim a As Control
'*************
On Error Resume Next
'*************
For Each a In Me.Controls
a.Enabled = False
Next
Command1.Enabled =
End Sub
For Each a In Me.Controls
If TypeName(a) = "CommandButton" Then
a.Enable=False
End If
Next
End Sub