comment

  1. K

    VBA Code to insert image automatically into comment box of each item number from item list

    Dear Everyone, this forum had always been a great help even though I have only used it passive so far. However, I stuck with the following problem and could not find anything to solve it. In my table are item numbers listed in the first (A) column. I want to insert a comment box to each cell...
  2. L

    Macro To Comment Based on another Sheet

    Im trying to create a macro that comments based on another sheet I set up with the text in proper order (ie. A1 on Comment Sheet has Comment that should be in A1 for Sheet 1 and so on). I'm struggling with automating this one, does anyone know how to do this?
  3. L

    Auto comment Box

    Hi all, Looking for some help on Comment boxes I would like to auto position all comment boxes to setlocation closest to cell. e.g. All comments to be placed N1:NN9 (Top of sheet) So if a comment was entered in cell BH33 or BH 11, itwould automatically get re positioned between to BH1:BH9...
  4. B

    VBA Question - Populate Comment with Cell Value from Formula

    I'm in need of some code that will put the values in the cells of Column D into a comment of the associated name in Column B. I do not have room in the worksheet cells to put this info and thought including the information as a comment with the person's name might be a solution. Column D...
  5. D

    Making Comment Indicator Transparent

    Hi all Question relating to Comments using Excel 2010. I have a sheet that contains a huge amount of comments making the sheet itself very difficult to read. Is there anyway of making the comment indicator transparent? Or This there anyway of not displaying the comment indicator but the...
  6. T

    VBA Time Stamp Comment Box

    Sorry if this is redundant, I am looking for a VBA Code that will add a comment of date and time and keep the string of updates in the comment field so I can see how many changes that particular cell went through. I need to this to be able to work for each cell independently as each one will...
  7. Black Panther

    VBA to autosize comment box in MS Excel 2011 for Mac NOT WORKING in MS Excel 2016 for Mac

    I'm now using MS Excel 2016 on a MacBook Pro running macOS 10.12.6 (High Sierra) and the following code which worked well in MS Excel 2011 generates the error below in MS Excel 2016 and I'm unable to resolve the issue! Dim Commnt As Comment For Each Commnt In Application.ActiveSheet.Comments '...
  8. F

    Comments "shrinking" after copy and pasting

    One of my workbooks at work has starting doing a strange thing, right after I protected one of the spreadsheets. I made it so that only a selection of cells could be edited, with the remaining unable to be even selected. When I copy and paste an identicle region of cells in another spreadsheet...
  9. M

    i dont see " edit comment " as a choice on my sheet

    I instal windows and office in my new ssd. I transfer all my data also. After that, i cant write any comment on my excel page. In no cell. Why ?
  10. C

    VBA question for .AddComment in With statement

    Hoping you can help troubleshoot what part of my code is causing it to hiccup. This procedure will be called from another, and is intended to make identical changes (i.e. add several Comment boxes) on various sheets within each workbook in the user-selected network folder. It has run...
  11. M

    Some Kind of Comment Box

    My old business partner thought comment boxes were a great idea. He is gone and I have these boxes that pop up when you are in a cell. However, they are not normal Excel comment boxes. I don't know what they are called, I can't edit or delete them. I'd prefer to get rid of them all together...
  12. V

    Insert a comment at once in the same cell from grouped worksheets

    Hello! Is any other method to insert at a time a comment in the same cell (e.g. A1, B5, F10 etc.) from some grouped sheets of an Excel workbook? If I try to do it in the classic mode, after having grouped the respective sheets all the icons from the Comments section of the Review windows are...
  13. J

    Need to compare data in multiple workbooks

    I have 2 spreadsheets that I need to compare. I need to run a macro that compares data sets in both spreadsheet and then outputs the differences in a new book. It needs to check that that line PART NUMBER exists in both files, and that the QUANTITY matches. If there are differences, it should...
  14. M

    Macro to create comment in cell based on vlookup to cell in another sheet

    Need help with an Excel macro related to cell comments. I have a workbook with two worksheets. Sheet2 is where I input master data into a table. On Sheet1, I use formulas (mostly vlookup) to present Sheet2 data into a specific format. Overly simplified, this is the format of the two...
  15. B

    scrolling within a long comment needed

    Some of the comments in my cells are very long. Is there a way to immediately scroll to the last line when I open it? Also, once the comment is opened is there a way to do a find within it and have the cursor position itself at the found line? Thanks in advance to all those who reply. Dan
  16. A

    Automatically wrap text in a merged cell of a protected sheet

    I have tried a lot of different code that does not work. What I am looking to do is this: I have an excel template that users should not be able to edit the top portion of a form but they need to be able to add comments to the bottom portion of the form, to do this I have protected the sheet...
  17. E

    reorganising data

    Hi, my job (joy of joys!:eeek:) is to collate the different reports that we get in from different departments around the organisation... and there is one really repetitive aspect of it that leaves my fingers (& head) numb from all of the copying and pasting. I'm hoping that somebody may be able...
  18. B

    Appending (or prepending) to a comment, keeping comment format

    I have a workbook where i am comparing two worksheets that should be identical for the most part, including comments. When there is a difference, I am marking the cell yellow in the main sheet and then creating a formatted comment with details on what is different. As many of the cells have...
  19. F

    Auto-adding/removing comment & populating current date

    Hi all. I should probably start this by saying I suspect what I want to achieve requires VBA, something of which I have zero experience/knowledge, so might also need some pointers where to place any relevant code. Currently I have an Excel doc, and I have one column setup with some simply...
  20. K

    how to add a comment on the first cell where a specific value is found and loop it

    Hello, I am trying to write a macro and I am having a hard time figuring how to go about it. The end goal of the macro is to search if there is a value in column D starting at row 20, If TRUE then search for the first "TT" of the row and add a comment (value found in column D). Then do it for...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top