Private Sub Form_Load() Me.PopulateComboBoxes End Sub Public Sub PopulateComboBoxes() Dim Ctl As Control '# On parcours tous les controles de la Form For Each Ctl In Controls '# Si le controle observé est un ComboBox If TypeOf Ctl Is ComboBox Then '# On vide son contenu '# On y place les elements par default With Ctl .Clear .AddItem "Default 1" .AddItem "Default 2" .AddItem "Default 3" .AddItem "Default 4" .AddItem "Default 5" .AddItem "Default 6" End With End If Next Ctl End Sub