Userform / Spreadsheet Text Wrap

[BigPaulMc]

I have a text box in my userform. The text box has multi-line and word wrap set to True. When I transfer the data from the userform to the spreadsheet, the data appears as a long string. If I format that particular cell on the spreadsheet with word wrap, the content will wrap, but the cell does not resize. What could be going on?

Thanks,

[Richard Buttrey]

The VBE text box does not transfer its word wrap property to the Excel App. The Excel cell needs to be set to wrap text independently. Include the instruction

Please Login or Register  to view this content.

when you send the text box value to the sheet.

[BigPaulMc]

where do i add this?

[Richard Buttrey]

The obvious place would be in the same procedure that transfers the text box value.

[BigPaulMc]

I've added this code right below the instruction to transfer the notes text box data to the spreadsheet.

Please Login or Register  to view this content.

Range("$J$26").WrapText = True

Please Login or Register  to view this content.

The form transfers the data. The cell is populated. The wrap text button is selected for that cell. If I double click on the cell the data is there and wrapped; but the cell doesn't resize to show all the data.
what am i missing?

[Richard Buttrey]

Hi,

Any chance you could upload the workbook so that we can see in context?

[Richard Buttrey]

Which of the Text box events are you using?

[BigPaulMc]

I found out the auto resize to height does not work on merged cells...which these happen to be.

I'll have to figure something else out.

Thanks for your help

[Richard Buttrey]

I think you'd better upload the workbook so that we may see your problem in context. I assumed because you had mentioned a User Form and VBA that you were familiar with the VBE and how the code worked.