Displaying cell contents (from excel) in a text box

Occasional Visitor

I have managed to get the text box in excel to display the contents of a cell of another worksheet in the same workbook but it is not showing all of the contents. I've tried resizing it and changing various properties but can't seem to get all text in the shape.  Any ideas what I am doing wrong or is there a limit I don't know about?

1 Reply


with VBA macro this could be overcome

Sub SetColumnsRows()
With ActiveSheet.UsedRange
End With
End Sub

Additional Information:

Change the column width and row height