Line-breaks in Userforms freezes Excel

[shanilkarunananda]

Am using userforms on a spreadsheet to populate content to cells within a worksheet. The links are working perfectly and the data is being copied across precisely, from the userform to the cell and visa versa.
However, when a line-break is added (ALT+ENTER on the worksheet / ENTER on the userform) at any point, Excel freezes once I exit the cell or click away from the userform text box. This occurs when adding line-breaks on any text box on the userform.

I have removed all coding on the worksheet but the above issue persists; hence, not related to the coding.

Anyone able to help?

 

[Yongle]

welcome to the forum

Does the problem happen if you do this?
... open NEW workbook
.......enter something in a cell
.......... add a line break with {ALT}{ENTER}

 

[shanilkarunananda]

Cheers for the welcome!
Happens when I add a line break in the userform text box / cell to which the userform text boxes are linked.

 

[Yongle]

We are both using 365 - but I cannot replicate your problem as picture below illustrates
I can insert line breaks either in the textbox (enter) or if I enter directly in the cell (alt enter)

Am I doing something different to you?

This is what I am doing
- Insert Active-X textbox on the worksheet
- Link to cell
- Enter behaviour set to TRUE
- Multiline set to TRUE

 

[shanilkarunananda]

I'm using Userforms which is embedded within VB, which is then linked to cells on the tab. Have attached the where the form sits within the VBA, as well as the properties of the said text box.

Thanks.

 

[shanilkarunananda]

^the form and the cell is link through the "ControlSource" line found within properties.

 

[Yongle]

Again I cannot replicate your issue

I named cell A4 LinkedCell

I used that as control source property for the textbox in the useform
EnterKey behaviour = TRUE
Multiline = TRUE

And displayed the userform
... placed text with linebreaks (enter) in TextBox
... closed userform
... added text with linebreaks (alt enter) in cell A4
... displayed the userform

The link works and the text contains the correct line breaks in BOTH cell and textbox

 

[Yongle]

Close Excel completely

Open a NEW workbook (must be NEW!)
Do ONLY what I did above
- Create Named Range LinkedCell with refers to = A4
- Create a UserForm
- Add textbox amending only ...
. ControlSource LinkedCell
. EnterKey behaviour TRUE
. Multiline TRUE

Display the userform and test

Does EXCEL crash this time ?