I added a command button (ActiveX) to my worksheet that when clicked, it automatically runs a macro that either inserts comment thread if no comments are present in specific cell OR adds an additional (reply) comment to existing comment thread in specific cell when one is already present.

Currently, the button works fine when no previous comment exsists in desginated cell - but of course, gives me a runtime error when button clicked if a comment thread has already been inserted.



The idea behind this is to create a designated area for adding notes/comments for a workbook that different people use to enter site's intake volumes as loads arrive. We previously had a column specifcally used to add comments however, I'm revamping the sheet and was hoping to "liven" it up some with differnent features. Any ideas is more than welcomed.