Define width of label in VBA?

[WatfordKev]

I'm setting up an Excel userform in VBA, and populating labels based on lists - the labels are wrapping longer list items, as the label width is too short for the longer entries.

So - I either need to set the width to an arbitrary size or (preferably) set the label text to NOT wrap, but I can't find how to do this

 

[RoryA]

The label has a WordWrap property that you can set to False. You can also set it to autosize.

 

[Norie]

Kev

There is a WordWrap property for labels but you'd probably still need to resize to view all the text.