VBA Code to copy comments using click button

[RN12345]

Hi,

I have a work sheet with codes categorized on Page 2- column A and Comments for that code on Column B and Explanation of the code on Column C. When I am working, I have to search for each codes, read the explanation and then copy the comments to paste it into another document.

I have created buttons with code name on page 1. Please help me to have a code that can assign to the click button on page 1, that when I press the button, comments belongs to that particular code on page 2 (Column B) should be copied to memory, so that I can paste it to any other documets as I required. Also a message should appear with the explanation on Column C for that code. In this way I can save time by just a click on the code button.


Note: Sample work book is attached

Thanks..Please help me to find a solution..