1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| Sub usf()
Dim Str As String
Str = "102 - 25 04 2014 - SOCIETE - POSTE.PDF"
Str = Right(Str, Len(Str) - InStr(Str, " - ") - 2)
UserForm1.TextBox1 = Left(Str, InStr(Str, " - "))
'MsgBox Left(Str, InStr(Str, " - "))
Str = Right(Str, Len(Str) - InStr(Str, " - ") - 2)
UserForm1.TextBox2 = Left(Str, InStr(Str, " - "))
'MsgBox Left(Str, InStr(Str, " - "))
Str = Right(Str, Len(Str) - InStr(Str, " - ") - 2)
UserForm1.TextBox3 = Left(Str, Len(Str) - 4)
'MsgBox Left(Str, Len(Str) - 4)
UserForm1.Show
End Sub |
Partager