Picture Macro ...
Oct 16, 2009
I copied this from another post and am having trouble getting it to work for me. I want to be able to run this macro, find a picture on my computer which could be located anywhere and then have it paste in specific cells.
Whenever I run this it lets me find the picture I want and when I select it I get error message that says "compile error" Syntax Error". It then does not put the picture on the sheet.
I tried to zip and attach the work sheet multiple times but keep getting error message and won't let me attach......"forum excel database has encountered a problem" ....
View 9 Replies
ADVERTISEMENT
Mar 19, 2012
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?
View 1 Replies
View Related
Nov 18, 2007
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
View 6 Replies
View Related
Jul 19, 2007
A macro, which would allow me to click on a particular cell, which will have an ID number (1 through 34), each ID# is attributed to a particular employee. These ID# are located in my spreadsheet in columns B & G, and the ID #'s begin initially in B6 & G6 and continue downward to B34 & G34. These ID #'s are used in a vlookup type formula which covers 35 pages of this workbook. What I'd like to do is be able to click on any cell between B6& B34 (and/or the same in G6&G34), which has a particular ID # in it and have the photo of that particular employee designated with that ID# pop up in a window generated by the macro. I hope this makes sense! Any help would be greatly appreciated. My 1st sheet in my workbook is my "lookup" tab, which contains my ID# list and numbering sequence affiliated to each employee. So I'm not sure if I'd need to put the photograph of the employee in a column next to the employees name or have a folder designated with all my pictures in a certain directory, etc.
View 11 Replies
View Related
Feb 23, 2009
I use the following macro to open excel files. Can this be modified to open a picture ppppp.jpg?
. . . or, can someone help me with a new macro that can open pictures
. . . I would still like to have the file checking options to see if the picture is already open and if not, that it actually exists.
View 11 Replies
View Related
Oct 11, 2009
I'm watching an educational D V D on my computer, and take notes in excel. I repeatedly use the print screen command, then go to excel and paste in the picture, though it is too large. I resize it to 50% and I'm done. What kind of code do I need to use to paste and shrink the picture to 50%? Also, how do I attach a shortcut key to this action (for example Ctrl+M)
View 14 Replies
View Related
Nov 30, 2006
I have been able to piece together something that works great for me till i tested it on a item that I did not have a picture referanced to it.
I am looking for some help with what i guess is an "if" statement that if no picture is found paste "Sorry no picture found" in c3.
Here is code
Sub Copy_Cells()
'Copying the row
addr = ActiveSheet.Shapes(Application.Caller).TopLeftCell.Address
Intersect( Range(addr).EntireRow, Range("b:ak")).Select
Selection.Copy Sheet2.Range("b65536").End(xlUp).Offset(0, 0)
Sheets("sheet3").Select
'Picture code
MyPicturesName = Sheets("sheet3").Range("i5").Text
Sheets("sheet5").Shapes(MyPicturesName).Copy
Sheets("sheet3").Range("c3").Select
ActiveSheet.Paste
Range("a1").Select
'hide tabs
Sheets("Sheet1").Select
ActiveWindow.SelectedSheets.Visible = False
End Sub
View 4 Replies
View Related
Jun 18, 2014
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.
View 6 Replies
View Related
Aug 13, 2012
I have a picture that has been inserted into a worksheet via a macro and I have a number of macros to increase and decrease size. They work fine.
However, whenever I run one of those macros by selecting a button on the worksheet, it results in a border around the picture.
Facts:
- worksheet is called "Admin"
- picture is called "ClientLogo"
- Line.Weight set to "0" or "False" or "xlNone" or removed all result in a border
Question: Code / syntax for removing or setting the border to nothing?
VB:
Sub ReduceShape()
Dim shp As ShapeRange
On Error Goto NoSelectionMade
Sheets("Admin").Shapes("ClientLogo").Select
Set shp = Selection.ShapeRange
[Code]...
View 2 Replies
View Related
Sep 30, 2012
I am making a spreadsheet file for our football offcials group to review rules.
I tried to record a macro to copy a shape and put it into the spreadsheet, but the shape does not copy.
How do I get the shape to copy into the spreadsheet?
What I want is for them to "think" what they would do and then click the macro and it will show them where the ball would be after the foul/fouls.
View 2 Replies
View Related
Apr 18, 2014
The following macro enables be to insert picture from a given location. My query is I want to insert the picture name once the pictures are inserted in the excel worksheet.
[Code] .....
View 3 Replies
View Related
Feb 27, 2009
My macro generates some graph from some datas. Datas are in some range and when I filtering it shows only filtered values. I use Fixed axis (min and max) because if I use Auto it fit data to the window.
My problem is: I would like to use Auto axis because my layout would be better but bacground picture remains the same and it's useless. Background picture should change as I change filters.
example:
untitled.JPG
here is picture:
current situation is 1.
With Auto axis I get 2. (blue B and green D are filtered results)
And I would like to have 3.
Is it possible that background picture variate as datas variates?
View 11 Replies
View Related
Apr 25, 2014
macro which can show a picture of a certain cell and if I change the value of that cell the picture will be changed to the new cell value,
Like
If I put in cell A1 value DOG, so the pic in cell B1 is a dog pic that I defined before, and if I change that value to a cat, the pic should be changed to another pic.
View 1 Replies
View Related
Mar 13, 2014
I'm working on a dashboard that shows some market developments. One of the problems is that I'm using linked pictures and a combo box to choose the appropriate graph, but sometimes the picture link returns a blank. Apparently this is a bug that can be fixed by running a macro that refreshes the picture link. Unfortunately I'm a real beginner with this kind of stuff.
View 1 Replies
View Related
Jun 7, 2014
Basically, I am curious if I were to insert a value into say cell A1, is there any way B1 could display a picture I've saved. To be a bit more specific, A1's value would be 777, and B1's inserted picture would be 777.png saved on my PC. This would need to apply for the whole of the sheet for all the values in column A.
View 5 Replies
View Related
Mar 31, 2014
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.
View 7 Replies
View Related
Jun 28, 2014
I need to be able to select a pic from a client's folder and imbed that pic for my report.
View 1 Replies
View Related
Mar 5, 2009
I just upgraded to Excel 2007 and my macro from Excel 2003 for inserting a picture doesn't work correctly in 2007. I have a command button that states insert picture and when you click it, it will let you insert a picture into the cell and hide the command button. In 2007 it will let you insert the picture, but it isn't centered and expands into other cells and the command button is still visible. The picture appears to be the correct size it just doesn't center itself in the cell and the command button is still visible. Below is the
View 3 Replies
View Related
Jan 22, 2009
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.
View 10 Replies
View Related
Sep 1, 2012
Trying to create a macro to run through the following steps when I select a chart and run the macro:
Paste>As Picture>Copy As Picture>As Shown When Printed>OK
I used the macro record feature and when I enter the shortcut it always returns the same chart. How do I get it to run on whatever chart I have selected instead?
I am constantly using this function to copy charts from Excel into PowerPoint presentations and am frustrated with all the extra steps it takes (versus just Ctrl-C).
View 9 Replies
View Related
Jun 20, 2008
I am a complete newbie with the camera tool. Is there any way to make the camera tool dynamic so that the cells the tool is referencing can change upon the click of a button or some other form of switch? I am creating my first dashboard and this is the last step for my report to be completely dynamic.
-----------------------------------------------------------------------
Never mind, I apologize i just figured this one out...
Create a user defined formulaIn the UDF Create an if statementThe if statement's condition is the logistics in the shift mechanismThe value if true is the first group of cells you want in the snap shotThe value if false is the second group of cells you want in the snap shot, The range you want to toggle betweenRename the cell reference of any snap shot you have taken with the UDF name. In my example my UDF is "Dude" so when you select the camera tool it shows =Dude as the cell referenceReference a scroll bar to the conditional cell you selected in the if statement or choose statement. This is the shift mechanism
If you want to toggle between more than 2 sets of data use =Choose instead of =if
View 3 Replies
View Related
Mar 17, 2009
I am putting together a price list in excel and using images and hyperlinks to jazz it up a bit - what I am finding is that if I insert a 25KB GIF image, the excel file grows in size by over 100KB
why is this disproportionate growth happening and is there a way around it - I dont want my Price List growing too large but need the images....?
View 9 Replies
View Related
Mar 23, 2014
I want to paste/show a photo in a particular cell (D2) on a worksheet (called PP). I wish to delete any photo that may already be there in D2.
The picture's name (e.g. J-145.jpg) will be found in another sheet (called MP) in cell H1.
My pictures are stored in a folder (lets call it c:pictures) and the one I want has the same name (J-145.jpg).
I've tried many macros but none work.
View 14 Replies
View Related
Dec 6, 2007
i m working on a mechanical project , I need to do some modifications to my XLS file that i aint familair with.
http://aycu36.webshots.com/image/348...0572870_rs.jpg
View 10 Replies
View Related
Mar 27, 2007
I have several pictures on a graph sheet (i.e. imported cliparts) which I am using as a key to describe outcomes. I also have a blank picture box which I want to show each of the key pictures depending on a certain value in a cell on another sheet.
In Picture1 i want: fx = If(sheet1!A1 = "Red",Picture2,Picture3)
View 9 Replies
View Related
Jan 19, 2007
If I had a series of pictures in a worksheet, how could I give them a value so I could use the vlookup function?
View 14 Replies
View Related
Dec 4, 2008
Is it possible after inserting a picture in Excel and then shrinking it to the cell size un-shrink it to the original size by clicking the picture or placing cursor on the cell?
View 4 Replies
View Related
Jan 2, 2009
I am working with a spreadsheet created by a predecessor and there is a picture at the top of one of the worksheets. When I select the picture and hit Delete, it seems to work, but the picture is still there. When I move it around the worksheet and resize it, a copy with the same name ("Picture 47") remains in the spot I moved it from. When I delete the resized/moved picture, it deletes, but the picture still remains in the original spot.
When I record a macro and select the picture and hit delete - or even when I move the picture and resize it - the recorded macro is blank.
All of the pictures seem to be named "Picture 47"
View 6 Replies
View Related
Jan 26, 2009
Is there a way to have a picture set to a cell so when you put your mouse on it it will popup like the comments do.
View 2 Replies
View Related
May 12, 2014
how i can add a box on my sheet when i click on it to open the insert picture (or open picture). I need this for my recipes. I try the Image (Image ActiveX Control) but i do not now how to make it work. Also i try to insert picture each time but it takes me time to move it and re-size it every time. I need a faster way to add my pictures fast and in the same position every time.
View 5 Replies
View Related
