How to read left side cell value to the comment cell

I can read all comments in excel file using below code. How do I read left side cell value to the comment cell?

For Each mySht In Worksheets
    For Each mycomment In Worksheets(mySht.Name).Comments
                mycomment.Text                                
    Next mycomment
Next mySht

sample data:
A B C Col B comments
---------------
a1 b1 c1 b1 comment
a2 b2 c2 b2 comment

expected output:
------------------------
left side cell val Col B comments
----------------------------------------------------------
a1 b1 comment
a2 b2 comment


Please find attached test.xls for sample. Thanks.