Question posted 2009 · +7 upvotes
In a textbox of a userform in VBA, I would like to enable the feature where the user can add a new line in the textbox by pressing the “Enter” key on the keyboard. However, I had trouble finding a UI option in the UI editor to achieve this. Is this even allowed in VBA userforms? Thanks in advance for the advices and answers.
Accepted answer +18 upvotes
Set textbox’s MultiLine property to True and EnterKeyBehavior to True.
Top excel-vba Q&A (6)
- How to clear the entire array? +58 (2010)
- How to change Format of a Cell to Text using VBA +55 (2011)
- Download attachment from Outlook and Open in Excel +43 (2012)
- Can a VBA function in Excel return a range? +36 (2009)
- 2 Dimensional array from range +34 (2013)
- Hiding an Excel worksheet with VBA +33 (2009)
excel-vba solutions on this site
— top 15%.