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
Any ideas? Thanks in advance.