comment

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

Dear Everyone, this forum had always been a great help even though I have only used it passive so far. However, I stuck with the following problem and could not find anything to solve it. In my table are item numbers listed in the first (A) column. I want to insert a comment box to each cell...

Im trying to create a macro that comments based on another sheet I set up with the text in proper order (ie. A1 on Comment Sheet has Comment that should be in A1 for Sheet 1 and so on). I'm struggling with automating this one, does anyone know how to do this?