text box shows partial text from linked cell

[Eat More Bacon]

Why does my text box show only part of the cell contents of the linked cell? Using Windows 10 with Excel 2021

 

[vletm]

Eat More Bacon
The way You're using textbox - There is 256 character limit.

 

[Eat More Bacon]

So is there a different way to do it to get around the 256 limit?

 

[vletm]

Eat More Bacon
One sample
... save below code to Sheet1's code-page and run it.

Sub Do_It()
    With ActiveSheet
        .Shapes("TextBox 5").TextFrame.Characters.Text = .Range("K56")
    End With
End Sub

 

[Eat More Bacon]

Thanks! Now how do I run the code when I change K56?
Do I need to do that manually? Or assign a keyboard shortcut? Or can it be done whenever K56 updates?

 

[vletm]

Eat More Bacon
You seems to did many questions about - How:
#1 Modify cell K56 and press < ENTER >
#2 Modify V-column and press < ENTER >
#3 Click that TextBox