A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Have you set these 2 properties of textbox?
EnterKeyBehaviour = True
MultiLine = True
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have created a text box in excel 2007. when i press enter key to create a new line nothing happens.
i have press alt+enter, ctrl + enter but nothing.
i have also reinstaled the whole office suite.
can somebody give me a solution?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Have you set these 2 properties of textbox?
EnterKeyBehaviour = True
MultiLine = True
in the properties window.
you haven't said where exactly your textbox is.
If on a userform then in VBE, F4 to show properties window. Select the textbox and alter properties.
If on the worksheet you will need to go into design mode and use the Properties button on the developer tab. Again select the control before altering properties.
where i find this 2 properties ?