Forum Discussion
Displaying cell contents (from excel) in a text box
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 ...
with VBA macro this could be overcome
Sub SetColumnsRows()
With ActiveSheet.UsedRange
.Columns.AutoFit
.Rows.AutoFit
End With
End SubAdditional Information:
Change the column width and row height