ich versuche den Text einer Userform TextBox auf Zellen auf zu teilen.
Leider wird der Text nicht auf die Zeilen 1 bis 4 aufgeteilt.
Danke!
Gruß
Mirel
https://www.herber.de/bbs/user/165942.xlsm
Code:Private Sub CommandButton1_Click() Dim sArr() As String sArr = Split(TextBox1.Text, ". ") Cells(1, 2).Resize(UBound(sArr) + 1, 1) = Application.Transpose(sArr) End Sub
Private Sub CommandButton1_Click()
Dim arr, arrOut(), i&, j&, var$, iMax&: iMax = 41
arr = Split(TextBox1.Text, " ")
For i = LBound(arr) To UBound(arr)
If Len(var & arr(i)) = iMax Then
var = var & arr(i) & " "
Else
j = j + 1
ReDim Preserve arrOut(1 To j)
arrOut(j) = var
var = ""
End If
Next i
End Sub
Private Sub CommandButton1_Click()
Dim arr, arrOut(), i&, j&, var$, iMax&: iMax = TextBox1.Width / TextBox1.Font.Size * 2.1
arr = Split(TextBox1.Text, " ")
For i = LBound(arr) To UBound(arr)
If Len(var & arr(i)) = iMax Then
var = var & arr(i) & " "
Else
j = j + 1
ReDim Preserve arrOut(1 To j)
arrOut(j) = var
var = ""
i = i - 1
End If
Next i
j = j + 1
ReDim Preserve arrOut(1 To j)
arrOut(j) = arr(UBound(arr))
End Sub
Code:Private Sub CommandButton1_Click() Dim sArr() As String, i As Integer sArr = Split(TextBox1.Text, ". ") For i = 0 To UBound(sArr) Cells(i + 1, 2).Value = sArr(i) & IIf(i = UBound(sArr), "", ".") Next i End Sub