Inserting Specific Cell Into A Comment?
Sep 15, 2014
My situation is like this:
-I have two sets of data in two different sheets. The data is similar, but it is taken in two ferent times, so there are some cells, which content has changed.
-I want to make a macro that identifies the changes in the latter (newer) sheet compared two the older one and to:
a) Highlight the cells (this works)
b) Add a comment to each cell that has changed so that the content of the comment is the content of the "older" cell. (so that one can easily see from the newer sheet that highlighted cells have new values and the old values are in the comment) (this is not working)
Here's my code so far. Like I said I can't make the comment work. I tried it with the same text in all comments ("test comment") and it worked but I can't make it to go and get the data from my older sheet.
OLDER = my sheet with old data
NEWER = my sheet with updated data
NEWTABLE = my table on the NEWER sheet where I want to check the changes
[Code].....
View 7 Replies
ADVERTISEMENT
Mar 14, 2013
Is there a way to insert a pdf into a cell comment? I found how to insert an object but when I do that it covers the entire spreadsheet. I would like to be able to add pdf's to cell comments.
View 3 Replies
View Related
Jun 20, 2006
I want to select any cell on a spreadsheet, then run a macro that inserts a comment to the selected cell with the inserted comment text being the selected cell entry (value/text/ date). Primarily to insert a cell date value to comment before overwriting it with a tick to represent completion. The comment then contains the date for archive info purpose.
View 2 Replies
View Related
Feb 24, 2012
I have this code tat I am using to important a picture via a comment box:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$AI$10" Then
newpic = "J:help" & Range("AQ21").Value
Target.Comment.Shape.Fill.UserPicture newpic
End If
End Sub
The problem is if you put a value in AI10 that is not AQ21 it gives and error. I would like for it to call another cell (B3) for newpic in the case of a value that is not present in AI10.
View 9 Replies
View Related
Jun 17, 2008
I open Excel. I click Insert-> Comment. Excel crashes. I try to open an excel file with comments, Excel crashes. I have already uninstalled and reinstalled, Detected & Repaired. Nothing appears in the event viewer. I am at my wits end.
Any ideas on what this could be? My only guess is a windows issue vs. an excel issue, but I thought I'd at least ask.
View 6 Replies
View Related
Jul 13, 2009
is it possible to allow a user to insert an image into a comment box through a user form. For example-
User enters Part # into form - then in a separate form field - uploads an image from his/her hard drive. On submit the part number is populated into A1(or wherever) and comment box is also generated for A1 which contains said image.
View 4 Replies
View Related
Jun 7, 2006
i have this super huge worksheet im working with and im trying to insert a vlookup forumla at the first blank cell at the end of each column. for some reason when i tried:
Range("B" & lastrowB + 1).FormulaR1C1 = "test"
it worked but.. when i tried
Range("B" & lastrowB + 1).FormulaR1C1 = "=VLOOKUP(A2435,[tmp.xls]vRptMOMarkToHedgeFacilities!$A:$BF,7,0)"
it didn't work. giving me an error on that line stating: Run-time error '1004': Application-defined or object-defined error.
View 6 Replies
View Related
Sep 27, 2006
I am trying to create a spreadsheet that will have a lot if invoice totals (over 3000) can I scan these invoices and make them so they link to the cell the are refered to in the spreadsheet similar to a comment box?
View 4 Replies
View Related
Apr 8, 2014
I have entered the current format of the data and the required format as well...
View 3 Replies
View Related
Mar 3, 2014
I have a column with lots of rows. I want to locate a specific one and insert some data into this row at specific columns. This is what i have come up with so far:
[Code] .....
View 14 Replies
View Related
Jul 25, 2014
I want to insert a formula that is tied to a specific column. I know how to do formulas and have a slight understanding of macros. Can I insert the formula as part of a larger macro?
View 3 Replies
View Related
Mar 13, 2014
how to copy the contents of multiple comment boxes and paste in a single comment box.
The big picture is that I have a number of cells with numerical values in and text in comment boxes. I want to be able to click a button to copy the contents of the comment boxes and paste them, along with the numerical value from the cell, into a single comment box, ordered by highest to lowest value within the comment box, then delete the original cells and comments.
I am quite new to VBA but have been coping quite well so far with information of the web and analysing recorded macros.
View 6 Replies
View Related
Aug 16, 2013
I'm wondering if it is at all possible to have a cell comment automatically update depending on what data is input in the cell (via user input, VLOOKUP, etc.)?
For example, if cell A1 contains the text "CHARLES" with a comment saying "Employee of the Month", and is then subsequently updated with the new text "JOHN" (again, via direct input, a VLOOKUP, data validation, etc.) is there a way to have the comment automatically update to say something else, such as "Team Lead" for example?
I've considered using VBA to accomplish my goal, but am unsure how to compose an effective code to do so. I've also considered perhaps creating a named table filled with all the different comment possibilities I would like to have used in this cell and then inputting a formula in either cell A1, or the comment contained therein, that would then call the corresponding text from that table based on the data in cell A1. Honestly, I'm not sure that what I'm trying to do is even possible;
View 4 Replies
View Related
Feb 18, 2008
I have some code that finds the appropriate string for a comment from another sheet. I then want to add the string to the appropriate range selection but am encountering an Object Variable or With Block Variable Not set on this section of
Range("C" & i).Select
ActiveCell.Comment.Delete <== Here Or the Next line
ActiveCell.AddComment (Commenta)
ActiveCell.Comment.Shape.TextFrame.AutoSize = True
Where Commenta is the string value I want to add.
View 3 Replies
View Related
Mar 13, 2012
How, via VBA, would I add a comment from a userform (text box name: txtReason) into a cell that may already have a comment in it? I would like to keep the comment that is in the cell and then have the program add a "/" and the next comment from txtReason..
(using excel 2010)
View 2 Replies
View Related
Sep 7, 2012
I am working on a database and trying to remove duplicates. When there are duplicates, I want to take the contents of one cell and copy them as a comment on the cell above (or below).
I tried to work on a small macro to do so, but the contents of the cell cannot be copied (it comes out as a blank).
The long way is to 'double click' in the cell, Ctrl+A, cut, click the cell above, Ctrl+F2, paste. This way is very long as I have thousands of duplicates.
View 4 Replies
View Related
Nov 2, 2012
What is the best way to reference a cell in another workbook and return the cell contents and the comment on that cell. I would like the comment to come across as a comment in the new workbook becuase the comment is actually a picture.
Hope this makes sense. I did find a macro through googling but I couldn't get it to work? I don't really want to copy and paste because eventually I have hundreds of sheets & thousands of cells to refer to.?
View 2 Replies
View Related
May 18, 2014
I have a spreadsheet with some cells which return values using INDEX and MATCH to bring back the entire details of a person based on there membership number. However I require the comments to be attached with the returned values. The comments have there image in, rather than just text.
I have found some answers with vba, which do the process, however you had to manually enter the cell, from which the comment was to be copied from, into a pop up box. This involved finding the box myself to then select the box to take the comment from. In doing this I had found and read the comment, which is the is the process I'm trying to bypass.
View 8 Replies
View Related
Jun 25, 2008
I need to copy a cell content to a Comment into another worksheet in
the same cell ref.
sheet1
A1 = apple
A2 = orange
Sheet2 - target
A1 = comment (apple)
A2 = comment (orange)
View 9 Replies
View Related
May 15, 2008
i need to have a way to link a small picture/thumbnail to a cell. so that there is a way to preveiw it. Ideally like what happens with the comments where you hover over the cell and the comment would pop up. or failing that may be a cell linking to the image.
View 8 Replies
View Related
Jan 16, 2009
make the contents of the cell comment box dependent on the cell contents? eg if the cell contents = 2 and a seperate table says 2 is "poor" can it automatically populate the comment with "poor" ?
View 5 Replies
View Related
Jun 9, 2009
When I insert a comment in a cell, my corporate version of Excel displays my employee number. How can Code a cell to populate this employee number.
View 3 Replies
View Related
Aug 20, 2014
I'm using a function at the moment to copy the comment text from cells, but would like to Change it a Little. At the Moment I have:
[Code]...
There are 3 Basic Groups that the comments refer to, eg: If a comment is a 1,4,11,14 it's Group A. 2,5,12,15 are Group B, etc...
View 2 Replies
View Related
Feb 7, 2008
I've some code to add a comment with the value of the corresponding cell 9 columns across:
For Each rCell In rRng.Offset(0, 0).Resize(rRng.Rows.Count, rRng.Columns.Count)
On Error Resume Next
rCell.AddComment
On Error GoTo 0
rCell.Comment.Text "Previous value was " & Cells(rCell.Offset(0, 9).Value) '(rRng.Row, rRng.Column).Value
View 9 Replies
View Related
Mar 17, 2009
I have the code below, and it works perfectly on my Mac. But... on my PC it does not.
The cell comment does not resize horizontally when I enter text. So if I enter a long comment I get a comment box that extends far to the right to fit the contents in. Vertically it is fine, nothing cut off and no extra space.
Any ideas why this would be? Any ideas how I can force the text to wrap in the cell comment box?
Code is below:
Sub AddCom()
Const USERNAME As String = "Greer:"
Dim strCommentName As String
Dim cmnt As String
Dim NoMore As Boolean
Dim Pos As Long
cmnt = InputBox("Please enter a comment")
strCommentName = cmnt & vbLf & Now
On Error GoTo 0
With activeCell...........
View 9 Replies
View Related
Aug 14, 2009
I have a set of data with text in one cell and images in a cell adjacent the text to illustrate the text. I am trying to figure out how to add a comment to the cell containing the text and take the image in the adjacent cell and put it in the comment.
Is there a way to do this, or do I have to write a macro that saves the images as their own files and then insert the image files into the comment?
View 9 Replies
View Related
Nov 19, 2009
I'm using this formula on Sheet2 to populate a cell (copied across and down)...
=IF(COUNTIF(Master!$F$1:$F$300,$A2)>=COLUMNS($B2:B2),INDEX(Master!$B$1:$B$300,SMALL(IF(Master!$F$1:$F$300=$A2,ROW(Master!$F$1:$F$300)-ROW(Master!$F$1)+1),COLUMNS($B2:B2))),"")
In cell B2 Sheet2, I would like to have a cell comment that is populated by the data in Master! that is alongside the data looked up in this formula, this principle would apply to every cell in my range... Sheet2 B2:AC100.
So on Sheet2 B3 is populated by B11 from Master!, I would like the comment to be the value of A11 on Master!
View 9 Replies
View Related
May 23, 2007
I have a worksheet with about a dozen cell comments in one column. I am able to add and edit cell comments to other cells throughout the worksheete, but I can not edit any of the existing comments. I've tried all of the usual ways to edit the comment (Shift/F2, Insert-Edit Comment, etc.), but nothing opens the comment in edit mode.
View 3 Replies
View Related
May 28, 2007
if choose a cell then the code works fine, but when i choose a selection of cells
(ex. A1 A2A3 A4) then the code fail to excute in this line: Invalid proceduer call or argument error
.AddComment "hmk :" & Chr(10) & " value was " & ActiveCell.Value
and then fail to excute in this line: typr mismatch error
Selection.Value = (Selection.Value) * r
now here, does have to be loop to solve
here is the full code
Sub test()
Dim r As Integer
ActiveCell.ClearComments
View 5 Replies
View Related
May 15, 2008
i need to have a way to link a small picture/thumbnail to a cell. so that there is a way to preveiw it. Idealy like what happens with the comments where you hover over the cell and the comment would pop up. or failing that mabe a cell linking to the image.
View 6 Replies
View Related
