The With...End With statement executes a series of statements on a single object or user-defined type : Form Control « Forms « VBA / Excel / Access / Word






The With...End With statement executes a series of statements on a single object or user-defined type

 
Private Sub cmdWithEndWith_Click()
   With Me.txtAge ' Your Text Field's name
      .BackColor = 16777088
      .ForeColor = 16711680
      .Value = "Hello World"
      .FontName = "Arial"
   End With
End Sub

 








Related examples in the same category

1.Intrinsic Constant Type of Control
2.Determining the Type of a Control
3.Manipulating a Single Control
4.With...End With construct is often used along with the For Each...Next construct
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