ActiveX

To resize a cell based on the tallest data in that row

At run time,

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. 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.
3. Set the RowHeight property for that row equal to the variable from step 1.