Make Cells in a Spreadsheet Control in a Userform word wrap

I have a spreadsheet control in a userform for a vba program with excel. I need to make the cells in the spreadsheet control word wrap. However, I cannot see anything on the properties page to do this and there is no way to do it in any of the tabs in the custom properties dialog box. In addition, I tried the following but got a compiler message 'Object does not support this property'
userform1.spreadsheet1.sheets("Sheet1").Range("A1:H12").WordWrap = True
userform1.spreadsheet1.sheets("Sheet1").Range("A1:H12").MultiLine = True

Open in new window


Any ideas? Thanks in advance.

Joe
borgtamerAsked:
Who is Participating?
 
Rory ArchibaldCommented:
You can't wrap text in a spreadsheet control, I'm afraid.
0
 
dlmilleCommented:
Try this:
userform1.spreadsheet1.sheets("Sheet1").Range("A1:H12").WrapText= True

Open in new window

Dave
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.