Manipulating a Single Control : Form Control « Forms « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Forms
  3. Form Control

Manipulating a Single Control

 
Sub FormCaptions()
    Dim frm As Form
    For Each frm In Forms
        frm.Caption = frm.Caption & " - " & CurrentUser
    Next frm
End Sub








Related examples in the same category

1.Intrinsic Constant Type of Control
2.Determining the Type of a 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