View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Leighton Harker Leighton Harker is offline
external usenet poster
 
Posts: 1
Default Copying multiline textboxes from userform to worksheet cell

I have a userform that contains a multiline textbox with wordwrap.
This displays correctly on the userform.

I want to copy the contents of the textbox back into a worsheet cell
as follows

ActiveCell.Offset(0, 5).Value = frmAddIssue.TextBox2.Value

This works okay but the line breaks are displayed as 'square box'
characters in the cell - is there a way to avoid this?

Thanks in advance
Leighton