VBA Reading Cell's Comments

[NGUSER]

Thanks for taking my question.

How can I read a cell's content's in VBA. Be gentile, I'm a beginner VBA programmer.

Thanks.

 

[brian.wethington]

This would put B1 into a variable called Var1

Var1 = Cells(1, 2).Value

as would this

Var1 = Range("B1").Value

Hope this helps!

 

[Lewiy]

Do you mean content or comment?

Content would be something like:
Range("A1").Value

Comment would be:
Range("A1").Comment.Text