Private Sub Listb_BeforeDropOrPaste(ByVal Cancel As MSForms.ReturnBoolean, _
ByVal Action As MSForms.fmAction, ByVal Data As MSForms.DataObject, _
ByVal X As Single, ByVal Y As Single, ByVal Effect As MSForms.ReturnEffect, ByVal Shift As Integer)
Cancel = True
Effect = 1
listb.AddItem Data.GetText
ThisWorkbook.ActiveSheet.Cells(1, 1).Value = Data.GetText
End Sub