comment

  1. Ironman

    Assigning a comment to an entry in a dynamic chart

    Hi I have a dynamic chart showing the last 90 days' entries and there are one or two spikes in the data that I want to comment on. Right now, the text box I added is fixed to where I inserted it in the chart so when the next entry is added it's out of position and therefore meaningless. Is it...
  2. B

    Excel VBA - How to set a comment on a cell with VBA?

    How can i populate a cell with a comment using VBA code? And then how to make the text in the comment hold a cell´s value like A1 And how to make a new line in a cell comment?
  3. J

    Comment Box Size

    Can a comment box be configured with a set width and grow the height as required to fit the text *as I type* it? It could start as 100 characters wide x 1 line high but when I hit 101 characters it wraps to the next line and the comment box grows by a line vertically to show all the text...
  4. E

    Formula/Macro lookup comment/image

    Hi, I've got a workbook that I'm trying to have lookup a cell with a comment and image. If I enter data into the first sheet in A2, I'd like it to populate the corresponding comment and image from the second sheet in column H into the first sheet in column F2...
  5. E

    Vlookup comment with image

    Hi, I've tried searching for this online and can't find exactly what I need. What code can I use to have my comment and image load from column H on the second sheet into the first sheet when typing in the corresponding lookup value. https://imgur.com/a/bIdWfai
  6. J

    Adding Comments

    I'm writing a macro to add a custom comment. I have everything up to adding text to the comment working. How do I stop the macro from advancing while I'm adding text? Then once I'm done adding text, how do I detect a mouse click so I can turn the macro back on so I can finish and close the...
  7. J

    Open macro from macro

    This one is driving me nuts. These are the keystrokes I want to do in a macro- Tools Macros Macros Which should give me the screen with the list of my macros. I tried recording a macro but when I looked at the macro it was just sub and end sub with a comment between them. I googled the heck...
  8. E

    Adding comments automatically

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

    excel insert comment with photo macro

    Hello i have to make a long list where i have to fill a lot of text cells whit one particullary photo for each cell commentary like in this video: https://www.youtube.com/watch?v=Er-mjd4WOLU All i need is a macro for example when i press Ctrl+h to make the macro to insert comment delete the...
  10. H

    Where to edit comment of cells

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

    VBA: Adding a URL link into a comment

    I want my code in VBA to set a comment within a cell with a clickable URL iside it. I can do this manually like this: 1) Click in the cell and then insert a comment as "http://www.google.com.br" 2) Right click at the comment cell, and select Show/Hide Comments to show the comment. Done, the cell...
  12. E

    Format Comment using VBA

    I currently am able to use vba to comment a picture I have rooted in a specific cell, but am having trouble sizing it properly. My current code is below: Sub Comment() Set rng = ActiveSheet.Cells(9, 1) rng.AddComment rng.Comment.Text Text:="" rng.Comment.Shape.Fill.UserPicture...
  13. H

    Shortcut key for "new comment" - Excel 365

    Shift-F2 is still the shortcut key for inserting a new note (ex comment) but I cannot find a shortcut key for insering a new comment - Alt-RC will do it but nowhere near as easy; and my brain is wired for shift-F2 . Anyone, please?
  14. S

    Search in cell and comments at the same time

    Is it possible through VB to check for a specific value in a cell AND comment with one macro. Something like Range(“A1:H50”). Find=“010118”, LookIn=xlComments/Values ...!!! TIA
  15. H

    Macro to move to next cell

    I have a list of file names in Col A. Before running my macro for the first time, I select Cell A1, and it inserts a comment in C1 Once the macro has run I want it to the cursor to be on A2, then after running the macro select A3 etc The code that inserts the comment in Col C is as follows...
  16. K

    Image in Comment Based of Cell Value

    VB/Macro help! I am trying to create a way for a cell value which has a comment box in it as well to pull an image from a file destination based off the input in that cell. If someone types in a product ID into the cell the comment box will pull the image of the product on file. So far I have...
  17. C

    Index, match functions

    <tbody> A Cells, tissues and systems 1st 2nd 3rd 4rth </tbody> I want to create a formula - in which you can use drop-down menus for cells A1 and B1. These will then, in turn, look up another table and look up the criteria in cell A1 and B2. I also want it to look at the steps...
  18. T

    Formula Request (if possible) - VLookup or Index/Match using a criteria and ignoring blanks

    <tbody> A B C D E 1 Joe Bloggs 1.2 2 Your Manager Job Level Team Morale My Morale Development 3 Joe Bloggs 1.2 This comment is for Option 1 Just for visual Just for visual 4 Betty Sue 1.2 This comment is a dummy Just for visual 5 Joe Bloggs 1.2 Just...
  19. P

    Loop through all cells in a row, action if cell.comment

    I'm trying to write a macro that will open up all files in a given directory. That bits not an issue. However I want to loop through a specific row, outputting the following in to a Destination Sheet A & row = Workbook.name B & row = Cell.value C & row = value of cell 10 rows up from commented...
  20. B

    Split the content of a cell into separate rows

    Hello, I have to review a reconciliation file similar to the one below. The problem is that in column 5 (Comment) there could be cells that include a number of items, which makes it impossible for me to filter/analyse the data, (i.e. comments for item #3 ). Whenever a comment contains several...

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