comment

  1. G

    Hiding rows with Threaded Comments

    I am using Excel 365 and have a worksheet with a threaded comment. I wish to hide all rows from above this comment to the bottom of the worksheet. If this were a normal comment, now called "Notes", I could format the comment to move and size with cells and this would allow me to hide the rows...
  2. K

    UserForm textbox to textbox in sheet

    Hello there, I'm pretty new with VBA and I am trying to make a Userform to add comments to an excel sheet. I have a combo box with initials (of the person making the comment) and a text box where they will write the comment. Now if the person clicks the OK button I want it to start a new line...
  3. C

    Comment or Note: Auto Fill with date & time

    WITHOUT doing a VBA is there a way that a note/comment can auto fill the date and time as well as the person's name? Thank you :)
  4. S

    VBA auto email

    Hi all, We have a tracker for stock waiting to be booked in. When our warehouse has booked in the stock, they enter 'Closed' into a particular cell, add a comment, and the line turns blue. How can I set the spreadsheet up so when the warehouse enter 'Closed', an email is created with the...
  5. G

    VBA code not working in a Range

    Hi Guys, I have the following code to add a comment each time a cell value changes, however if I change the Range to "N25" everything works perfectly, but if I want to have the code to cover all rows in column "N" I don't get any comment appear when the value changes. Private Sub...
  6. T

    Copy Active Cell Comment to next empty row on another worksheet

    I am trying to find a way to automatically copy any cell comment from worksheet1 in range H7:H5 as text to the next empty row on worksheet2 Is there any way to do this?
  7. T

    drop down list for comment

    is there anyway to have a selection list to choose from instead of writing a comment in the comment box? Here is what I would like to do: If any cell in range H7:H37 , J7:J37, L7:L37 (which are populated by a validation list) is less than 5, then a comment box would pop up offering the...
  8. A

    number to word

    HI is it possible to see the number/amount in words if we hover mouse cursor on a number in excel as a comment not in any cell, it will show as a comment box and when we move the cursor from the number the comment should vanish thanks dinesh saha 9932022569
  9. A

    Formatting Data in a Text File from Exported PDF Comments

    I am trying to format a text file, that is the result of exporting PDF comments from Adobe, into a table when I import it. The text file is formatted like this, with the comments on a certain page being located beneath the page number. Summary of Comments on RandomDocmument.pdf Page: 1 Author...
  10. A

    Insert picture in comment box (through fill effects → picture → insert picture)

    I was able to insert picture in the past in my comments through insert comment → fill effects → picture → insert picture. But not anymore: the system is spooling and it tells me that I can do it through "work offline". I click offline and nothing happens. Anyone experienced this? I have excel...
  11. T

    combine data from one column into one cell based on a criteria

    I have a column that has comments and I would like to combine those comments into one cell which =concat does but how can I add a comma and space between the comments from each line Column 1 = Topic Column 2 = Comment Not every row has a comment though Your help would be greatly appreciated
  12. K

    VBA CommentThreaded 'show'

    Hi, I would like to show a threaded comment (with notes it is straightforward, we put them on 'visible=true') when activating a sheet. Is there a line of code to show those threaded comments ? I noticed there is a "show comments" in review tab but recording macro does not help. Even if I add...
  13. U

    Macro/VBA to insert a comment mandatory when selecting a dropdown option

    Is there a macro or vba code i can use so that when cell C6 dropdown is selected, a message box appears for the user to insert a comment mandatory? I would like to use this for multiple cells i.e. cell C6 dropdown 'Resource' is selected, message box appears saying 'Insert Comment'...user...
  14. L

    create comment from adjacent cell contents

    Hi, I am trying to create a comment from the cell contents in an adjacent column (offset -1) for a range. The purpose is to create a popup comment that represents a part description when you hover over the part. <tbody> Part Number Part Description part 1 part 1 desc part 2 part 2 desc...
  15. R

    Auto copy comment on new cells of dynamic table?

    Hi there. I have a dynamic table named Tabla, with two columns named A and B and I want to every cells on that columns (new ones that can be added with TAB key increasing table size) have the same comment. In the screenshot that i've attached, you'll see the first row commented (with LIMIT...
  16. R

    does comment in a cell contain a picture.

    I'm trying to determine if a cell contains a comment with a picture. While I tried this way and it failed, any which way that works would be fine. I found this code: <code>Set shp = Range("C4").Comment.Shape if shp.Fill.TextureType = msoTextureUserDefined then end if</code>...
  17. P

    Quick way of adding an image in a comment (popup picture)

    I work regularly on a particular type of Excel document that requires me to insert images so that my colleagues can understand what I'm referring to (related to mechanical design and a picture speaks a 1000 words as they say). In order to keep the document neat and tidy, I insert comments and...
  18. A

    Comment with scroll bar

    Can I create a comment template with a scroll bar using VBA which gets trigger through a command button
  19. A

    Comment box with VBA, which pops- up on mouse hower

    Hello Everyone , I want to put a comment to a cell using VBA through command button. Once the comment is entered the cell is dimmed. The comment can be viewed by hovering the mouse on the cell, through a pop-up or button.
  20. R

    Copy comment automatically on all cells in a column in a dynamic table?

    Hi. There is a way to apply the same cell comment to new rows that be created using TAB key? Thanks for your time.

Some videos you may like

This Week's Hot Topics

Top