Private Sub CommandButton1_Click()
TextBox1 = [K9]
End Sub
Sub USF()
UserForm1.Show 0 'non modal
End Sub
Private Sub CommandButton1_Click()
'nécéssite d'activer la référence "Microsoft Forms 2.0 Object Library."
With New DataObject
.GetFromClipboard
TextBox1 = .GetText()
End With
End Sub
Private Sub CommandButton1_Click()
'nécéssite d'activer la référence "Microsoft Forms 2.0 Object Library."
With New DataObject
.GetFromClipboard
TextBox1 = Replace(.GetText, vbCrLf, "")
End With
End Sub