comment

I'm using a bunch of sheets like forms and pulling the values to the main sheet with =INDIRECT(E1&"!b2") where E1 is the sheet name I would like to add comments to the same cell from the corresponding C cell Ie. cell content =INDIRECT(E1&"!b2") cell comment =INDIRECT(E1&"!C2") Is there a...

You can easily to retrieve the comment in a cell but I am looking for the reverse Sub Example() Dim oComment As Comment Set oComment = ActiveSheet.Comments(1) MsgBox Not (oComment Is Nothing) ' <== TRUE proves oComment variable holds a pointer to the comment object...

My intention is to color fill a specific cell (e.g. A1) with a click of a button (Button1) I've created. Another click of a button would un-fill the color. Another question that is not a priority is to open a "new comment" box for a specific cell for user to start entering in their comment with...

The way my current code works is like this: I have a command button that when clicked, it copies all the text inside all the cells within a certain range, and inserts them into comments for those cells. This works 'ok', but it takes a really long time when its running the code... I even...

Hello, I am developing a few macros dealing with comments. I notice that if a user happens to place (or accidentally leaves) his mouse cursor inside a comment box (e.g. after editing a comment), and then clicks on any macro button, the button does not work. He should first move his cursor out...

Hi, My goal is to trigger a macro when a comment is added to a cell (otherwise, the cell is not modified) from the column B. I was given this script to place at the root of the sheet, which applies to a given cell (B2) instead of the column B. Private Sub Worksheet_SelectionChange(ByVal...

Good afternoon, I am trying to find a certain cell value, and when it finds it, past a static value in the cell next to it. It is an error report, and there are 5 error columns, starting with "Reviewer Error 1 Comment" up to "Reviewer Error 5 Comment", and next to each of those there is...

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

Hi, Everybody I want to make my Excel comments occupy as little space as possible, since my worksheet may contain so many. So, I remove the User Name in all comments if they were created using "Insert Comment" I also want to remove all spaces represented by vbLf (if user hits Enter)...

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

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

Hi everyone, I'm a bit puzzled and need some advice and help. I have a calendar in excel with dates along the top and events down column A Now when we have something happening the cell turn red so for example if we have a meeting on 20/04/2019 with Wembley stadium it shows in that cell...

Hello Everyone, Could someone let me know if there is a way to add the results of a calculation into the comment for a selected range? if so, could the results in the comment change if any of the values change? GM% Formula:(Customer A Price - Cost) / (Customer A Price) <tbody> Cost Customer...

I have a sub that searches for cells with formulas that contain a specific string. When I execute the code directly from the module, it runs in about 1 second. If I execute the macro from the developer ribbon or use a shortcut, the time jumps up to 10 seconds. Has anybody seen that sort of issue...

Hi all, new to this great resource. I am trying to figure out how to do the following: On worksheet "S" I have a range of n x m dimension that is dynamic, and I want to test the string value (alphanumeric) of any given cell on worksheet "S" against data I have on a separate worksheet "R" of a...

Sub PictureInCommentSize() With Application.FileDialog(msoFileDialogFilePicker) .AllowMultiSelect = False 'Only one file .InitialFileName = CurDir 'directory to open the window .Filters.Clear 'Cancel the filter '.Filters.Add...

Hello i need your help : At work we need an excel file whit a comment photo for each thing as you can see in this example: https://imgur.com/a/kwSobuM To do this we use this macro : Sub PictureInCommentSize() With Application.FileDialog(msoFileDialogFilePicker) .AllowMultiSelect =...

Have many rows with dated notes/comments in a single cell. Need to extract the notes associated with the most recent date. See example below: <tbody> 2/1/18 - comment one comment one 1/27/18 - comment two comment two 12/25/17 - comment three comment three (result) 2/1/18 - comment one comment...

Trying to get an input box to pop up so a user can enter abrief comment that will then appear in a comment attached to the cell. Theproblem I believe I’m running into is the user inputs data into a table on onesheet which feeds results over to another sheet; Sheet X. It is the results in...

Hi Team, I have a macro that works fine that adds a comment to the cells but if there is one there already it will stop. What I was hoping to do was rather that delete the comment, could I append another comment to it rather than delete and lose the previous one? Code as below for the part...