http://www.contextures.com/xlUserForm01.html

within above sample, is it possible to when click on "Add this part", it
will pop out a box called "Add comments" for users to add comments. And the
comments will be capure inside the new worksheet.

Thanks.