Comments on userform to be applied to worksheet

[ipbr21054]

Morning,
I have a userform which data is entered then sent to my worksheet.
I am then having to manually insert a comment into the cell at column D

How is it possible to wright on my userfrom & that comment is inserted into thats cell at column D

 

[mikerickson]

Add a textbox to the userform and put that textbox's entry into the comment you want.

 

[Yongle]

amend sheet name, textbox name, variable used to determine row number etc

    With Sheets("Sheet1").Cells(RowNumber, 4)
        .Comment.Delete
        .AddComment
        .Comment.Text Text:=Me.Textbox10.Text
    End With

 

[ipbr21054]

Before i do that let me say it anyway just incase i didnt explain correct the first time.

My userform info is sent to the worksheet.
Now i then go to cell column D and wright NOTE
Once NOTE is shown in the cell i then right click & insert comment.
So my worksheet cell shows NOTE with a red marker in the top right corener of that cell.

I dont want to wright on the userform in a text box, This textbox text sahould be this long
So when i look at my worksheet it shows in cell D, This textbox text sahould be this long

Worksheet should just show NOTE with, This textbox text sahould be this long behind it like hidden

 

[ipbr21054]

See photo example


Cell D1269 has the word NOTE
Put your mouse over the word NOTE to see the comment.

It is this comment i wish to type on my userform to be inserted on my worksheet.

I dont want to see all the comment writtem in cell D

Did i explain ok ??

 

[Yongle]

You said
How is it possible to wright on my userform & that comment is inserted into thats cell at column D

That is what my code does - but that does not appear to be what you want
But I do not understand what you want

 

[ipbr21054]

On the worksheet do this.
Click a cell & right click then select INSERT COMMENT
Type your comment Example HELLO
When you then leave the cell you will see a red marker in the cell advising you there is a comment.

When you then hover mouse over the cell with that red market the comment is shown.

 

[ipbr21054]

See my short video example

click to see example

 

[Yongle]

I hope someone else understands what you want
I am leaving the thread

 

[ipbr21054]

What do you not understand ?

I do not wish to right click on worksheet then insert comment.

I would like whilst userform is open to wright comment then when its sent to worksheet have it already applied with red marker like in my video