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,
|