UserForm ListView - autofit rows?

[mike.magill]

Hi,

I am developing a UserForm that I want to use to show an extract from a Table on my worksheet. I'm currently using a ListView object to display this but cannot find a way to expand the row height (ideally automatically) to show more than one line of text in a cell. Any ideas how to do this or a better alternative to ListView?

Currently I'm using a couple of additional text boxes to show the additional lines. It's a bit clumsy.

I've attached an extract to show what I mean.

Thanks

[grimes0332]

There is no way to change the ListItem row height. Can't really suggest an alternative.