comment

  1. 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...
  2. 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>...
  3. 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...
  4. A

    Comment with scroll bar

    Can I create a comment template with a scroll bar using VBA which gets trigger through a command button
  5. 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.
  6. 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.
  7. A

    comment box/ Form for entering comments and it opens as a pop up

    Hello, I am trying to create a worksheet with a timetable and some time slot needs some action and the detail of the actions needed to be entered. Can i create a form that takes input and store it as a comment and when the cell is selected the pop-up/window can displays the comment in a...
  8. M

    Moving and locking a Comment Box

    I have a comment box that displays in a very bad position on my Excel 2016 Spreadsheet. Even when I move it under the Edit Comment Function, when I hover over the cell, it still displays in the the comment box in the original position. Is there anyway I can lock the comment box in the location...
  9. O

    VBA Code to Break a Comment into Multiple Lines

    Thanks in advance for any solutions, suggestions or help for which I will give feedback. I have two questions which are similar, but not exactly the same: (1) How do you break a comment such as the following into multiple lines (i.e. continuation)? This is basically so I can keep it on the...
  10. J

    VBA code- insert comment box

    Good Morning all a few years ago in an old job some one helped me create this piece of code which adds a comment box once someone adds anything to a cell i'm getting a run time error can you please help thank you Jason error: Target.Comment.Shape.TextFrame.Characters(1...
  11. N

    VBA code to lookup cell value and give a description as a comment

    <tbody> Unit Qty Unit Desc TR-010 10 TR-010 Trenching in Roadway TR-030 30 TR-020 Trenching in Sidewalk TR-030 Trenching in Grass </tbody> Hello, I was wondering if there is a vba code that can vlookup the value of a cell and return a description as a...
  12. T

    Help with adding comment from scripting dictionary item

    I'm using this code, although I've amended it a bit and one of the things that I want to do is to get it to add a comment in to a cell With CreateObject("scripting.dictionary") For Each Cl In Ws2.Range("A2", Ws2.Range("A" & Rows.Count).End(xlUp)) If Not...
  13. B

    Formula based values in comment

    Hi! I was wondering if it is possible to show the result of a formula in the comment section. Based on what product ID is showed in B4 I would like to show the result of an VLOOKUP function in the comment section of C4. Thanking you in advance for any tips!
  14. B

    If or statement

    hello, i am trying to do an IF OR statement for a sheet that looks like this <tbody> Column A Other Non BAU Event-Use Comments Other-Use Comment Box </tbody> so i want it to return a 1 if the fields say either of those items i tried this but it didnt work: =IF(OR($A2="Other Non BAU...
  15. A

    Show a Comment

    Could someone help me with this code please? From a d-click in Sheet1 I want to display a Comment that's in a different worksheet. Its location is SheetAC Col Jxxx. xxx is "The RowNumber" below. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel =...
  16. L

    VBA - How to invert/sort line breaks within a cell

    Guys, how can we change the line breaks order within a cell? For instance, in my cell I have the values: A1 Cell <tbody> 1st Comment 2nd Comment 3rd Comment </tbody> I want to invert to: <tbody> 3rd Comment 2nd Comment 1st Comment </tbody> For a more complex case, how to Sort based on...
  17. A

    How to add picture as a background of comment? Excel/VBA

    Hi, I Would like to add picture as a background of cell comment, When i click on the cell comment should be show with the background picture, Does anyone know how to can do it? Regards!
  18. S

    Comment section of next step list, capture date, feedback at the current date and change the revision of the next step

    Good day, I have a next step list where each next step listed has a comment section in column G, the comment section is usually only one cell with the text. Every meeting the feedback must be captured with today's date then feedback from the project manager and then if next step is not...
  19. 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...
  20. K

    Hyperlink multiple words in the comment section

    I am attempting to hyperlink multiple words in a comment section on Excel 2016. When right clicking on a work in the comment, the hyperlink is grayed out and dos not allow for a hyperlink. The only option is to hyperlink the entire cell. Is there a setting that needs to be changed in order to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top