I want to create a comment box in cell A1 on Sheet 1 using a macro.
The comment box will have 3 lines of text.
Line 1 = text from cell A1 on sheet 2.
Line 2 = text from cell F1 on sheet 2.
Line 3 = text from cell E1 on sheet 2.

I want to eventually create 100 comment boxes on Sheet 1 with information from sheet 2.
Not sure how to start this ... thanks for any assistance.