I'm trying to do something with pictures that have been inserted into cell comments. I'd like to be able to copy a picture that had been inserted into a cell comment, and save as .jpg with file name and file location designated by other cells in the spreadsheet. For example A1 contains "monkey" and has a picture of a monkey inserted into a comment on the same cell. B1 contains "zoo". I'd like to copy the picture from A1's comment and save as monkey.jpg to location c:zoo. Is this kind of thing possible in VBA?
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.
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.
I want to have a sample file in excel which store picture of student in comment, I did this, but when I want to insert picture the file dialog appears, and if I click cancel, then there is an error, why? If some one optimise the code it would be very nice
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.
It mentioned something about getting comments which display dynamic data as if something metioned in the cells will appear in the comment and on changing the data in the cells, the data in the comments also changes with it..
Unfortunately, I could not save that file or remember the website as my Internet went bonkers...
There are two sheets to the workbook. On Sheet1 I have created a search button for the user. Also, I have entered all of the data that will be searchable (though I'm still having trouble hiding this from sight from the user). When the user clicks the button, a MsgBox appears and they can do a keyword search for all of the data. I know they could simply hit ctrl+F, but the users are not computer literate. If there is a match, within the data set, of the keyword that was entered, then the user's screen automatically takes them to Sheet2, and any matching data is filled in beginning in row 2. Row 1 has all of the appropriate titles for each column. This all works well, but there's a few things that I would like to implement.
First here's the code for the button on Sheet1:
Code: Private Sub Search_Click() Dim SearchThis As String Dim FirstAddress As String
[Code]...
What I would like to accomplish, as I have found it to be a problem, is only have the button search for Column A's data on Sheet1 instead of all of the columns. I tried to change things around, but couldn't quite get it. The problem is, if there is data in column A and C (part number and description of part) matching the keyword, then the same item will be duplicated on Sheet2 when it is copied over.
Secondly, and the more difficult task, for each row on Sheet1 that there is a part (let's say it's a harness or bracket), I would like to include an image of said harness or bracket for ease of the user to know what they have searched. The problem so far that I have encountered is that the image will not copy over from Sheet1 to Sheet2 when the search is conducted. Is there some way to incorporate the image into the row to allow it to be copy and pasted onto Sheet2?
Finally, and this may not be difficult either, I would like to hide all of the data that I have entered on Sheet1 from the user to keep things simple when the program is used. I tried hiding rows, but when the search is conducted with the button, it cannot see the data and says there are no keywords that match. From what I've gathered, when copy and pasted to Sheet2, the program copies exactly what is in the rows on Sheet1. Therefore, I cannot make the text white, as you will not see it on Sheet2. The only other thing I could think to do is to begin the data entry around row 100 or so, that way the user wouldn't even consider looking that far down the sheet. Is there anyway to perform this better?
I have a sheet made into a form with some check boxes included. If I select all the relevant columns, create a new sheet, and paste into cell A1 - all of the information carries over just fine. You can still select cells and check the boxes in the new sheet.
However, when I record this action as a macro, using the macro produces a picture of the selected columns instead of actually copy/pasting the information. I can't click on the cells or check boxes. I can only move the picture around within the new sheet.
I have done the above where when I select a picture name from a drop down list it displays the relevant picture in another cell by using the IF function in the named formula
My question is why cant I use VLOOKUP instead of IF in the named formula. When I use it it comes with an error.
i have saved some pictures in my excel sheet. in the next sheet i want that when i write the picture name the picture will appear as vlookup helps in the getting text and nos. can i do this with pictures or i tried to get to much from excel.
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.
In Excel 2010, is there any way to paste a picture into a small picture/diagram box, and upon double clicking the picture it would explode to a larger size? And I guess double clicking it again would make it return to its original (smaller) size. I would be pasting several pictures into several different picture/diagram boxes and would need this to be a relative reference so that upon selection it explodes the appropriate picture?
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;
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
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..
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.
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.?
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.
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" ?
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.
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
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
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?
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!
