Word Wrap VBA to Specific Column Width

[vahnx]

I have a database in excel, here's some sample data.

When they click the print button in Cell A2, up comes my form

When the print tags button is pressed, my secondary sheet is populated with the cell they clicked on

Now it's using a font, calibri 11, which isn't proportional but I was wondering if there's a way in VBA to "auto" detect the max width and place words on the next row accordingly (like a word wrap). Here's what I need it to look like:

Here's my existing code to place the comments as is:

                entireComment = "Comments: " & Range("P" & i)                
                .Range("A" & cnt + 11).Value = Mid(entireComment, 1, 33)
                If Len(entireComment) >= 36 Then
                    .Range("A" & cnt + 12).Value = Mid(entireComment, 36, 35)
                End If
                If Len(entireComment) >= 71 Then
                    .Range("A" & cnt + 13).Value = Mid(entireComment, 72, 35)
                End If
                If Len(entireComment) >= 106 Then
                    .Range("A" & cnt + 14).Value = Mid(entireComment, 107, 35)
                End If
                If Len(entireComment) >= 141 Then
                    .Range("A" & cnt + 15).Value = Mid(entireComment, 142, 35)
                End If
                If Len(entireComment) >= 176 Then
                    .Range("A" & cnt + 16).Value = Mid(entireComment, 177, 35)
                End If
                If Len(entireComment) >= 211 Then
                    .Range("A" & cnt + 17).Value = Mid(entireComment, 212, 35)
                End If

This is one of the last hurdles in a project I'm working on.

 

[JLGWhiz]

This is out of the VBA help file, but you can probably figure out how to use it.

Code:
<CODE>Worksheets("Sheet1").Range("B2").Value = _
"This text should wrap in a cell."
Worksheets("Sheet1").Range("B2").WrapText = True
Code:
</CODE>

 

[vahnx]

Thank you so much! Much simpler solution than what I attempted.

 

[JLGWhiz]

Thank you so much! Much simpler solution than what I attempted.

The VBA help files are not that easy to use if you are not familiar with the conventions and VBA language. But the more they are used the easier it gets.

Regards, JLG