Private Sub UserForm_Activate()
Dim i As Integer
For i = 1 To 12
ComboBox1.AddItem (Format(DateAdd("d", (i - 1), Now()), "[$-21]dd mmmm yyyy;@"))
ComboBox2.AddItem (Format(DateAdd("d", (i - 1), Now()), "[$-21]dd;@"))
ComboBox3.AddItem (Format(DateAdd("m", i, Now()), "[$-21]mmmm;@"))
ComboBox4.AddItem (Format(DateAdd("m", -1 + (i - 1) * 12, Now()), "[$-21]yyyy;@"))
Next i
End Sub
Dim i As Integer
For i = 1 To 12
ComboBox1.AddItem (Format(DateAdd("d", (i - 1), Now()), "[$-21]dd mmmm yyyy;@"))
ComboBox2.AddItem (Format(DateAdd("d", (i - 1), Now()), "[$-21]dd;@"))
ComboBox3.AddItem (Format(DateAdd("m", i, Now()), "[$-21]mmmm;@"))
ComboBox4.AddItem (Format(DateAdd("m", -1 + (i - 1) * 12, Now()), "[$-21]yyyy;@"))
Next i
End Sub
untuk php bagaimana caranya?
BalasHapusFaktual News