load data to cell comments
 

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,

load data to cell comments
 

Here's an example:

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

--
Dan

On Dec 20, 8:34 am, Souris wrote:
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,

load data to cell comments
 

Thanks for the message

"Dan R." wrote:

Here's an example:

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

--
Dan

On Dec 20, 8:34 am, Souris wrote:
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,