ActiveX
To resize a cell based on the tallest data in that row
At run time,
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
- Return the minimum height necessary to display the tallest data in a specific row with the MaxTextRowHeight property (specify the row using the lRow parameter) and assign it to a variable.
- Set the RowHeight property for that row equal to the variable from step 1.