VBA - Enter array into multiline textbox on userform

Question

I want to enter each element of an array onto a new line in multiline textbox on a userform. I have the Multiline and EnterKeyBehaviour of the textbox set to True.

The code below will enter the array elements but after entered they are then overwritten by the next element.

For i = LBound(clipArray) To UBound(clipArray)
        frmMyForm.txtBox.Text = clipArray(i)
Next

I have tried variations like below (with vbCr, vbCrLf etc) but still does not work.

frmMyForm.txtBox.Text = clipArray(i, vbNewLine)

How can I fix?

FaneDuru · Accepted Answer · 2022-06-25 14:13:18Z

1

Please, use:

   frmMyForm.txtBox.Text = Join(clipArray, vbLf)

answered Jun 25, 2022 at 14:13

FaneDuru

42.3k4 gold badges22 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA - Enter array into multiline textbox on userform

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related