comment

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

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

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.

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

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

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

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

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

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

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

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!

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

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

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

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!

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

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

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

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