Determining the Type of a Control : Form Control « Forms « VBA / Excel / Access / Word






Determining the Type of a Control

 
Sub FlipEnabled(frmAny As Form, ctlAny As Control)
    Dim ctl As Control
    ctlAny.Enabled = True
    ctlAny.SetFocus
    For Each ctl In frmAny.Controls
        If ctl.ControlType = acCommandButton Then
            If ctl.Name <> ctlAny.Name Then
                ctl.Enabled = Not ctl.Enabled
            End If
        End If
    Next ctl
End Sub

 








Related examples in the same category

1.Intrinsic Constant Type of Control
2.Manipulating a Single Control
3.With...End With construct is often used along with the For Each...Next construct
4.The With...End With statement executes a series of statements on a single object or user-defined type
5.The For Each...Next statement executes a group of statements on each member of an array or collection
6.Change fonts of controls on a form
7.change control back ground color
8.Control Types
9.Controls and Errors