comment

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...

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...

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...

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...

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 '...

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...

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 ?

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...

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

In Word, you can the ruler to see measurements of tabs, indents & spacing. I know that the comment boxes in Excel do not have that capability. However, I'm fairly certain I have seen VBA code that does show measurements like this within comment boxes. Is there a "reveal codes" for text in...

Hello guys! I am currently doing a qualitative analysis of short comments. I have created a spreadsheet with comments as rows and categories (or 'codes') as columns; so that for the comment "I like ice cream and tea", I will tick the category "food" and "beveridge" ("ice cream" being included in...