comments

Hi, I understand (from surfing the net) that we can hide and show comments in Excel by using: Application.DisplayCommentIndicator=xlCommentIndicatorOnly (to hide comments) or Application.DisplayCommentIndicator=xlCommentAndIndicator (to show comments) However, this will hide or show ALL...

Hi, I am trying to develop an Excel VBA application which will do the following. What I am trying to do? I have Sheet1 which is populated by an SQL Stored Procedure from data in a server, when a button is pressed. As the sheet is very complex, I permit the user to add any helpful comments...

Hi, I have an Excel Sheet1 with data in it and several comments scattered here and there. I think each comment has an identification number automatically assigned to it when it is created? Maybe ID? or Item? Not sure! I want a VBA macro to list all the comments to another sheet (say Sheet2)...

...Is there any way to do this other than creating many separate Sheet locations to store unique comments? Each time the user returns or moves to ANY cell with pre-entered comments, the Userform listbox or textbox would reflect those Comments for that particular cell, displayed in a list ? The...

Hello, Trying to get a value into sheet A from a cell in either sheet B or C where a cell on either sheet B or C equals a certain cell on sheet A. I have linked the workbook to understand better. Comments are in the summary sheet in cells C13 & E13...

Hello, I am new to the forum as a registered user. Can you help me with a source code or something in vba? What I need is to gather data with HLOOKUP and comments from another workbook and put them altogether in another. I need this because the initial file is in the server and is being...

Can't get the formula right. I have two tabs in a spreadsheet with many rows and columns. I need to pull the need contrac t a nd comments from Tab 2 to the corresponding address in tab 1 (which has a bunch of other info in it) Trying to use index match (don't want to use vlookup- long story)...

I wish to link the information from a sheet in one workbook stored on sharepoint to another sheet in another workbook stored on sharepoint , I wish the whole cell contents to link including the colour and comments but using the paste special link function only the data links across. I have also...

Hi good morning all, Please can help with the code below, the section half way down where it says Comments: I want this to be in bold, I have tried <b> but this didn't work, please can you help me? Private Sub CommandButton2_Click() If TextBox9.Value = "" Then MsgBox "Please enter...

Hello all, I am using this formula to pull a list of survey comments for employees from a raw data sheet. It is working fine but Id like to not have all the blank results in between the ones that have comments. Any Suggestion on how to alter this to no include the blanks...

Hi all I have a number of spreadsheets that have comments in many of the cells within them. Is there a way to copy from each spreadsheet all the comments into a spreadsheet (for totals) The problem I have is that to do this it deletes the ones already copy/pasted. There are far too many to copy...

Hello! Is there a way to change the colors in the Font-Color Palette in each "Comments" area, in Excel 2016? I'm thinking there MUST be a way, but I've been stumped on this for quite a while! With Thanks in advance, ~ DWR

So MS has renamed the old Comments to Notes, and the new Comments have become threaded conversations. We're now using Notes in the same manner as we used to use Comments. The problem is, EDIT NOTE nor NEW NOTE appear in the right-click menu when in a cell that has a Note, only DELETE NOTE. Is...

Hi there! I'd like toknow how is possible to make dynamic comments based on a filter in a pivottable by using a Macro or VB. Thank you!

Hi All, I have survey results that come out like the attached. I need to produce a report from this and would like to have a table by each area. Eg. Alignment to Outcomes and list the comments without the blank cells, and then the "agree, diagree etc... " I tried using the below, but it...

Dear All, In excel sheet, Column V has a history of comments. Commentsare recorded by the date then Name of the person then status and then thecomments. Please see the below example (these all information in cell V2): 10/9/201810:20:32 AM(Date) - Hanneli (Name) : Status - Response...

Howdy, I'd like t knowif someone knows about how to add diferents comments in a cell depending on whatdo you select in the filter on a pivot table. Thanks inadvanced!

Hi, I have a worksheet which I want to display the comments only from a questionnaire but based on whatever is selected from a list on data validation. How would I achieve this? Vlookup obviously just picks out the first but I need something so the formula makes it drop a row each time to...

Hi, before i start to explain my problem, I'm a complete rookie when it comes to VBA, however I've got a fair amount of knowledge when it comes to formulas. I would like to know if its possible to add comments automatically, depending on the contents of the cell. For example the comment is...

Hi, Where can I edit comments of the cells below? https://1drv.ms/u/s!Ai8CrEskdewXm1cbebVD-Mm-OXrN