Displaying cell contents (from excel) in a text box

Question

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.&nbsp; Any ideas what I am doing wrong or is there a limit I don't know about?

nikolinode · Answer

healthwa2022&nbsp;with VBA macro this could be overcomeSub SetColumnsRows()
With ActiveSheet.UsedRange
.Columns.AutoFit
.Rows.AutoFit
End With
End SubAdditional Information:Change the column width and row height&nbsp;&nbsp;

Forum Discussion

Displaying cell contents (from excel) in a text box

1 Reply

Resources