load data to cell comments

[Souris]

I would like to retrieve data from my database to the spreasheet.

I just wanted to know is it possible to load data in to comments to the cell.

We can right click and see the comments for that particular cell which
stored in my database.

Your information is great appreicated,

 

[Dan R.]

Here's an example:

Sub comments()
For Each cell In ActiveSheet.Range("A1:A10")
cell.AddComment "Cell: " & cell.Address
Next cell
End Sub

 

[Souris]

Thanks for the message

Here's an example:

Sub comments()
For Each cell In ActiveSheet.Range("A1:A10")
cell.AddComment "Cell: " & cell.Address
Next cell
End Sub