Userform Textbox value to cell as comment indicator

[Maleko-1]

Hello,
I am trying to transfer a TextBox value from a Userform to a cell on a spreadsheet but I would like the value to be viewable on the spreadsheet as a comment indicator (where you can hover the mouse over the cell to view the contents). Is this possible?
Any help with this would be much appreciated.
Thanks
Marc

 

[JamesW]

Hi there,

Try:

Private Sub CommandButton1_Click()
    Range("A2").Comment.Text Text:=TextBox1.Value
End Sub

 

[Maleko-1]

Thanks for the reply.
If I may ask.....
My userform has a TextBox1, TextBox2, and CommandButton. I need to send the value of TextBox1 to a cell in column H on Sheet1 and TextBox2 to the cell in column P in the same row on Sheet1 when enter is clicked. I would like the values in both columns to be viewed as comments on the spreadsheet. I also need the next entry from the userform to add as comments in the next row down and so on.
Any help with this would be very much appreciated.

Marc

 

[Maleko-1]

I am still trying to figure this out. It sounds like it would be easy but I am stumped.
Any kind soul willing to help me with this?

Thanks in advance

Marc