How to start a new line when press Enter key in textbox?

When you input contents into an ActiveX textbox which is inserted from the Developer tab, the contents will be displayed in one line. This will be very annoying when viewing the whole content, in this case, you may need to start a new line after pressing Enter key in the ActiveX textbox. This article, I will introduce a quick method to solve it.

Start a new line when pressing Enter key in textbox

Start a new line when pressing Enter key in textbox

To finish this task, you just need to set some attributes in the Properties dialog box, please do as this:

1. Click Developer > Insert > Text Box to insert an ActiveX textbox, see screenshot:

2. Then click Properties under the Developer tab, then in the Properties dialog box, under Alphabetic tab do the following operations:

(1.) Choose True beside the EnterKeyBehavior text box;

(2.) Select True beside the MultiLine text box.

3. And then close this dialog box, and exit the Design Mode. Now, when you input contents into the textbox, after pressing the Enter key, the data will be restarted from a new line. See screenshot:

Unlock Excel Magic with Kutools AI

• Smart Execution: Perform cell operations, analyze data, and create charts—all driven by simple commands.
• Custom Formulas: Generate tailored formulas to streamline your workflows.
• VBA Coding: Write and implement VBA code effortlessly.
• Formula Interpretation: Understand complex formulas with ease.
• Text Translation: Break language barriers within your spreadsheets.

Enhance your Excel capabilities with AI-powered tools. Download Now and experience efficiency like never before!