comments

  1. G

    VBA Updating Comments to Active Cell

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

    How can we count the Hidden and Visible comments in Selection?

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

    Pull in names and comments from one sheet to another based on date range and criteria

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

    How to remove all line breaks, leaving only single line breaks?

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

    Macro for hiding and unhiding Comments.

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

    Formula to pull in name based on criteria from one worksheet to another

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

    "comments" section missing off "review" tab

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

    Delete all comments which are blank or contains User Name

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

    On a sheet with many comments, is it possible to spread them out so as not to hide other comments?

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

    Excel VBA: Application.DisplayCommentIndicator

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

    Copy all comments from one worksheet to itself after refreshing the data?

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

    How to list certain details about all comments in a worksheet?

    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)...
  13. C

    displaying activecell comments in the same userform textbox or Listbox, updated as the activecell changes...

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

    Compare 2 sets of cells over different worksheets and return a value in a different cell

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

    HLOOKUP with Comments

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

    Need to consolidate based on criteria without macro or vlookup

    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)...
  17. A

    Linking Cells in Excel

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

    how to add bold to a section in my email vba code

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

    ByPass Blank cells in formula

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

    copy paste multiple comments?

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

Some videos you may like

This Week's Hot Topics

Top