Private Sub UserForm_initialize()
frmfabricant.Textdatecreation.Value = Format(Now, "dd/mmm/yy")
Dim cell As Range
With Sheets("bdfabricant")
For Each cell In .Range("c4:c" & .Range("c2000").End(xlUp).Row) 'c est la colonne de l'information du nom à modifier si ajout de colonne
mdrfabricant.AddItem (cell)
Next
End With
End Sub