VBA > UserForm > enter array of strings via any control

Question

Is there any control for UserForm that allows entering multiline text? If no, any advice how to get array of strings entered manually via UserForm?

The only way after 5 minutes of brainstorming is to use TextBox + 'Add' Button to add entered strings to ListBox and then read content of the ListBox control.

Mukul Varshney · Accepted Answer · 2017-01-15 00:04:11Z

2

Use multiline property of the textbox. Set it to true. Then you can split the text with new line into array. See below

Dim stringArray as Variant
stringArray = Split(txtBox1.Text, vbCr) ' You may use vbLf or vbCrlf

answered Jan 15, 2017 at 0:04

Mukul Varshney

3,1511 gold badge14 silver badges19 bronze badges

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

1 Comment

John Coleman Over a year ago

Maybe you could also mention changing the EnterKeyBehavior property. Otherwise multiline behaves counter-intuitively (at least to many people).

dgorti · Accepted Answer · 2017-01-15 00:01:20Z

1

Use TextBox, go to properties, set multiline = true

answered Jan 15, 2017 at 0:01

dgorti

1,2802 gold badges15 silver badges23 bronze badges

Collectives™ on Stack Overflow

VBA > UserForm > enter array of strings via any control

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest