comment box

Hello to all, I want to know if I can copy text in one cell on Sheet "test" and paste into a new comment on Sheet "report". I've seen some codes that go the other way around, extract the comment and move to another sheet. Kind of want to go the other way. Any ideas? Stay smooth, KeythStone

Hello everyone. Seeking help on a function i want to create in a worksheet that mimics the "comment box" function but with a twist. I would like the user to be able to click a cell (A1) and then a userform with a textbox will appear to the right of it. The user then inputs a comment , hits...

I've inserted comments in many cells to use as an audit trail on my spreadsheet. Now when I open the spreadsheet, many of the comment boxes have closed up and moved far away from the original cell. All I can see is the call-out box line. Is there a way to reformat all of them to restore...

Can anyone offer some advice on how to possibly display information via 'comments' using VBA? I'm guessing that someone may have done this before.

I have a set of data with text in one cell and images in a cell adjacent the text to illustrate the text. I am trying to figure out how to add a comment to the cell containing the text and take the image in the adjacent cell and put it in the comment. Is there a way to do this, or do I have to...

Does anyone know how to change the default format for the comments box? Currently my name appears in the comments box, along with bold 10 point arial font text. I would like to change this to a different, non-bold, font and to not have my name appear. I've looked in tools/options and also...