Option Explicit
Const MyDateLong As String = 'dddd dd mmmm yyyy'
Private Sub UserForm_Initialize()
With Sheets('feuil1')
TextBox1.Value = Format(.Range('b1'), MyDateLong)
TextBox2.Value = Format(.Range('b20'), MyDateLong)
End With
End Sub