Comments box in cell "red information marker" next line code required

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
3,698
Office Version
  1. 2007
Platform
  1. Windows
Evening,

From my userform i type in a textbox & send this to a cells comments box.
Ive formatted how i would like the box to look but need one more edit & im complete.

Here is the code in use to format my comments.

Rich (BB code):
         With ActiveSheet.Cells(lastrow + 1, 4).Comment.Shape
                .Fill.ForeColor.RGB = vbCyan
                .LINE.Weight = 1#

                With .TextFrame
                    .AutoSize = True
                    With .Characters
                        With .Font
                            .Size = 12
                            .Name = "Calibri"
                            .Bold = True
                        End With
                    End With
                End With
            End With
    Else
         .Cells(lastrow + 1, 4).Value = TextBox6.Text
    End If


My goal is to be able to force the text on the userform to the next line as currently the comments box goes straight across the page.

I have attached a photo of what the current output looks like using the code shown above.

I have also attached a photo of what im trying to do.

hope this can be done.

Thanks
 

Attachments

  • 430.jpg
    430.jpg
    52.5 KB · Views: 4
  • 431.jpg
    431.jpg
    52.9 KB · Views: 5
  • 433.jpg
    433.jpg
    87.2 KB · Views: 3

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Watch MrExcel Video

Forum statistics

Threads
1,111,856
Messages
5,541,464
Members
410,546
Latest member
htran4
Top