Capture Cell Comments

[Oracle10g]

Hi,

Can Anyone help me.....

I want to now,how can we capture the cell comments from the excel sheet.


Thanks

 

[Mike Blackman]

Hi,

Just an exaple;

MsgBox Range("A1").Comment.Text

Can you let us know exactly what your trying to do with it if this doesn't help.

 

[Oracle10g]

Hi Mike,

Thanks for your reply.

Now I want the msg box value into a particular cell for further reference.



Thanks
K

 

[Mike Blackman]

Hi,

Something like;

Range("A1") = Range("A1").Comment.Text