comments

So I've got a bunch of comments in a spreadsheet and all the comments are of variable length. I try not to change the size of the default box if I can avoid it cause I've noticed if I increase the size or move it, the next time I look at that comment, the box has changed size and I have to...

Hi I am using the built-in function Transpose to convert an array to a string and would like to use the current selection ie change this Comments = Join(Evaluate("TRANSPOSE('Base'!A1:A10 )"), vbNewLine) to Comments = Join(Evaluate("TRANSPOSE(Selection )"), vbNewLine) The latter gives a...

Good afternoon Guru's I'm racking my brain with the best way forward on this. I have two spreadsheets (similar examples attached), one holding source data and the second is used for reporting. The source data comes from another source and therefore doesn't contain comments (column G). The...

Hi There, I need help to generate excel formula for below table.I need to put comments "value Zero" if my column"A" value nullify. below is the table. Please help me to get formula for this. <tbody> value Abs Forumal Comments -400 400 Value zero for 400 -400 400 Value zero for 400 400...

Hi! I have a sheet with a lot of comments which show additional information. With al the red right top corner triangles for every comments it gets very messy. Is there a way to not show these indicators? I found the 'no comments and indicators' function in Excel but this automatically removes...

Hello Everyone, I'm designing a sheet that is to be used as a tally for a strawman poll before a real vote is held on some projects being considered at my company. Some of these polls will have comments on them when returned. I'd like to list all comments, though most will be blank with no...

Hello! I have a userform with two sections. There are 4 checkboxes in each section with the idea that they will be pre-populated comments that will fill into a textbox. I am able to get it to populate text into the textbox when one box is checked however the way I have it written only allows for...

Sheet1: <tbody> 1 Cat 2019-05-21 Error... This, this, and this 2 Dog 2019-05-21 Error. This, this, and this 3 Mouse 2019-05-25 In order - that, that, and that 4 Fish 2019-05-26 Where, when, why, and how </tbody> Sheet2: <tbody> 5 2019-05-22 Dog ... 6 2019-05-22 Fish ... 7...

Dear All, good morning, I have a spreadsheet and I have added comments. I have - up to now - been able to edit the comments without problem. Today, I have tried to edit the comments but it won't allow me. When I right click / edit comments, the comments box won't open. Could someone advise...

An Excel spreadsheet containing any 'notes' (previously known as 'comments' in some earlier Excel versions) is slow to scroll up and down when using the up/down arrow keys. For example, even on a new workbook created as a blank workbook, after one 'note' is added (right-click, new note) in...

Hi all, Excel 365 here. The newer Excel version changed the old “comments” as “notes” (renamed this way), and added a new feature under the mention “comments”, which works like a thread with possible replies, where on top of input text, the autor is mentionned with a timestamp. I’d like to...

Hi Everyone, I'm looking to try and solve a problem with a calendar that's been created by the business. It's a crude way of our board being able to know when meetings are taking place throughout the year, it's built in excel rather than just using outlook but it's what they've decided...

Hi, We can Show or Hide a comment using the Excel Menu. Suppose I select a range on my Excel sheet. Say, there are 5 comments in that range: 4 of them are visible (Show comments) and 1 is hidden (Hide comments). How can we write a VBA macro that will count the number of visible comments, and...

I want to pull in the names and comments from the Detailed sheet onto the Snapshot based on a date range and a critera. The criteria is that Active or Appointment are not populated with X. Detailed: <tbody> Date Source Name Phone Email Comments Max Budget Active Appointment 2/4/19 REA John...

Hi, Everybody I want to compact all the comments on a worksheet to their minimum sizes because there are so many of them scattered everywhere on the worksheet. One way comments may occupy too much space is when the user inserts unnecessary line feeds in the comment box. I want to remove them...

I am looking to a macro that will allow me to use the transaction code to hide and unhide cell comments. I have the comments displayed but want to make a button that will hide them, much like a help button. In addition, I also need to make the same macro with the same purpose but able to work...

Hello I would like to pull in the fields "Name" and "Comments" from one worksheet into another based on the criteria "where Active = X"). So John Smith and his comments would get pulled into the new worksheet. Thank you <tbody> Name Comments Active John Smith lorem ipsum X Sam Smith...

hello, i have just changed my licensing for 365, and reinstalled all office 365 business apps. i have just opened a excel sheet i had and tried to edit the comments. the problem is that there is now no "comments" section showing under the "review" tab, and no comment option appearing when i...

Hi, I am writing a macro that will delete all comments (on the worksheet) that are empty. By "Empty" , I mean either of 2 things: (1) The comment box is absolutely empty: nothing in it. The user can create such a comment by selecting a cell and clicking a macro button. The macro...

Hi, I may just be dreaming... If there are many comments on a worksheet, and we click a macro button that shows them all, some comments may hide others, so we cannot read them all. My comments are programmed to autofit. So, they occupy minimum space. The button acts as a toggle button and...