Dim a As String 'VBA / VB.NET a = "AAA 111、BBB 2222、CCC 333333、DDD 44444444、EEE 5555"
Dim P As String, D As Variant 'VBA 'Dim P As String, D As Object 'VB.NET P = "A1" D = a