Delete/Remove Picture From Image Control
May 15, 2008
I want to delete a picture from an image control in a worksheet when pressing a button. So my code is:
Private Sub CommandButton1_Click()
Sheets("Sheet1").Image1.Picture = LoadPicture("")
End Sub
Well, the problem is that this code only works when I create it. If I save and close the excel file when I open it again and I press the CommandButton1 I get the following error: Run-time error '-2147417848(80010108)' Method "Picture of object "IImage" failed.
View 6 Replies
ADVERTISEMENT
Jan 5, 2007
I know how to load a picture onto an image control using VBA code, but how do I clear the picture? (NOTE: I am not talking about using the properties window in the VBE, I am talking about coding in VB)
View 3 Replies
View Related
Oct 14, 2008
I need to move a picture in a cell on a work sheet to a user form image box. I have tried loadimage(range("I3") however it will not work
View 9 Replies
View Related
Jul 21, 2014
How can i paste a picture from a workbook to my userform image control? Without having to create loads of code for this to be done? Ive tried something like this
[Code] .....
And cant get anywhere near doing what i want it to do.
View 3 Replies
View Related
Aug 9, 2007
I have an image box on a userform in Excel VB. Is there ANY WAY to load an image into this image box from an object that I have loaded into an excel worksheet something like
If userform1.checkbox1=True Then
userform1.image.picture = loadpicture (Worksheets("Sheet1").shapes("Object 1"))
ElseIf userform1.checkbox2=True Then
userform1.image.picture = loadpicture (Worksheets("Sheet1").shapes("Object 2"))
Else
msgbox "No image"
Endif
View 2 Replies
View Related
Oct 26, 2011
My workbook simply has multiple columns of data which will be summarized visually in a tag cloud (I have the tag cloud part taken care of already creating either a jpg or png, I simply have to change the extension within a batch file to change between picture formats)
I need to have the tag cloud image display and update depending on which column the user would like to summarize (for now I have simplified the issue by only having one of the data columns in my workbook, and will worry about the user selection of the data column to be summarized later).
My Main Question:
Focusing on the image display and updating now, whether it be an ActiveX Image Control or any other way. I've been playing around manually before I try and code it and I can not get either a jpg or png file to attach to the ActiveX control (both of which cause an Invalid Picture Message).
The file name can stay the same if need be and for now I think/assume that'd be easiest (I have my Tag cloud generator just replacing the previously existing image file of the same name).
Would ActiveX control be the way to go for this dynamically changing image?
View 9 Replies
View Related
Jan 22, 2012
I have a number of image controls on a user form, each being loaded with an image from file.
Image1 being loaded with a picture of a bus image2 being loaded with a picture of a school
And so on
Now what I am trying to do is when that image is clicked the name of that image is passed to a textbox
So the action would be
1 image of bus loaded into image control1 , the name of that image being bus.jpg
2 image is clicked
3 the name bus.jpg appears in a text box
Here is what I have so far
Code:
Private Sub Image1_Click()
DataInput.TextBoxItem.Value = bus.jpg
DataInput.TextBoxItem.Value= Image1.Name - this does not work
End Sub
Which works but as you can see this is static, as I have supplied the value , were as I would like the clicking action to pick up the name of the jpeg being displayed
So expanding upon this if say image1 is loaded with say a picture of a car instead of a bus
LValue4 = "E:Car.jpg"
Image1.Picture = LoadPicture(LValue4)
Now when it is clicked the name of the image being displayed in image control1 would be Car.jpg
And it is this value I wish to transfer to a text box for now will do more with it later
In addition to this I am not sure if the best idea is to have a number of image controls and load each with an individual picture or have one image control and swap the picture by clicking a command button
View 3 Replies
View Related
Jan 14, 2008
I am trying to display an image ("image") on an image control ("Image1") placed in a worksheet ("Sheet1"). The problem is that I want this action to take place when I press a button in a user form. I am trying to use the following code, but it seems that VBA does not recognize the image control ("Image1") in the worksheet.
Private Sub cmdDisplayImage_Click()
Dim image As Variant
image = ThisWorkbook.Path & "sun.jpg"
Sheets("Sheet1").Activate
Image1.Picture = LoadPicture(image)
End Sub
View 2 Replies
View Related
Jan 28, 2014
Trying to paste image/picture jpg into cell. Don't know enough basic to use earlier found code. Can't just image upload because image floats- not working in cell.
View 1 Replies
View Related
Dec 11, 2011
I have a created a worksheet button using an image holder (because I couldn't get the image to display properly on a normal command button) and when I click on the button, it distorts the picture because of its default zoom feature. I tried resetting the picture to its original size using the .height and .width properties but this produced an error saying the object doesn't support this property (weird because they were available through the suggestions menu that's available when you're coding). If I could just reload the original image, that would do the trick but I am not sure how to do that without using an file path that would only work on my PC and not on other users'.
View 2 Replies
View Related
Aug 27, 2006
I want to add an image to a sheet. The image is to print but I want the data from that sheet to go over the top. I can't seem to get the image behind my data.
View 6 Replies
View Related
Jul 19, 2014
I use the code below to insert an image and have it save with the file. I would like for the newly placed image/shape to be selected.
[Code] .....
View 3 Replies
View Related
Aug 21, 2014
I have a picture on my image at userform. And I want to change my picture size ( like attached picture: fast image resizer program ) and save as different location. It is my school project.
Your valuable macro codes about ıf this and attached workbooks are very important for me.
View 3 Replies
View Related
Aug 28, 2007
I have Image tool located at range B1:F36.
I have a simple VBA Code like as following.
Sub test
Sheets("Sheet1").Image1.Picture = LoadPicture("")
Sheets("Sheet1").Image1.Picture = LoadPicture(CFPicPath + CFPic)
Range("A1:G37").CopyPicture Appearance:=xlScreen, Format:=xlPicture
Sheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste
end sub
I have a problem at
"Range("A1:G37").CopyPicture Appearance:=xlScreen, Format:=xlPicture"
It always copy a blank picture to paste on sheet2.
How can I able to refresh IMAGE tool before copy range as picture ?
View 9 Replies
View Related
Sep 2, 2008
I have an Invoice setup for a Car Servicing Garage in excel. It does a few things:
1) On saving the workbook it will take a jpeg screenshot of the worksheet and save it locally
2) The name of the created jpeg file is taken from cell B9
Cell B9 contains the vehicle registration number. So, obviously my problem is that if a the same car comes in on more than one occasion (which happens frequently), the original jpeg will be replaced as the file name is not appended. This will mess up the invoice records. So what I would like is for it to acknowledge that a jpeg file with that name already exists and to just append a "_1", "_2", "_3" etc on the end of the original jpeg file name for the new jpeg file name. I have attached the my excel file so ideally, if someone could insert the necessary code or PM me that would be great.
View 4 Replies
View Related
Jan 24, 2014
I'm trying to make this macro work to resize images for our fashion Look Book. In theory, it should work. But of course it does not Here is the code we are using:
Code:
Sub BIGcrop()
Selection.Height = 507.6
x = Selection.ShapeRange.Width
y = x / 2
Z = y - 144
[Code]....
I want all my pictures to have a height of 7.05 inches and a width of 4. The height comes out different everytime depending on the scaling of the template I'm using. I need it to adjust accordingly. I'm open to having the image move into merged cells, as long as it will first adjust the height and then crop the sides (so the orientation stays the same).
View 4 Replies
View Related
Jan 13, 2014
I have a userform with multiple images
I would like to set all images to visible = false when images are dynamically named.
E.g. image names:
Image73om3
Image4y45h
Image12AB2
Is there a way to say
Code:
With all images
visible = false
End With
or
Code:
image*.visible = false
View 5 Replies
View Related
Aug 9, 2014
My final version will have more than 40 images with all the same code: they will all increment a corresponding SpinButton with 1.
[Code]....
View 13 Replies
View Related
Jan 11, 2010
my code brings up an empty dialog box.
The file I am trying to view is saved as follows: C: Test.gif
What I have done.Added a image control to a dialog box, called image1
Added the following event handler to image1:
x = c: test.gif
Image1.picture = loadpicture (X)Pressed F5 to test the code and brings up a dialog box with a blank image box.
Not called the userform in the main module (didn't seem much point considering the test failed)
My questions
where I am going wrong with this, the correct code?
Also in inputting the address of the file I could not use the C: format as this brought up an error. What is the correct format?
View 9 Replies
View Related
Aug 21, 2008
I am able to work out a code to upload pictures from my files using this:
Option Explicit
Private Sub cmdfind_Click()
Application. ScreenUpdating = False
Dim strfind As String
Dim rsearch As Range
Dim strfolder As String
Dim strname As String
Dim strpic As String
Dim b As Range
Set rsearch = Worksheets("m").Range("ap3", Range("ap65536").End(xlUp))
'define path to images
strfolder = "F:SEC FILESMAC2PIC"
'get data from userform
strname = frmsearch.txt201.Value
'check if pic exists
strpic = strfolder & strname & ".jpg".......................
How do i avoid the 'File Not Found' error if the picture is not available in my file folder?
View 3 Replies
View Related
Sep 14, 2006
i have a textbox on top of a picture box but i cannot replicate it with a new textbox or combobox.
when i place the control on the picture box it disapears?
View 9 Replies
View Related
May 12, 2014
I have a worksheet that contains a number of ActiveX image controls, which have been scaled to a uniform height to serve as thumbnails.
I have also created a class, where each instance is initialized with one of these image controls, and events (specifically the on click event) are captured. When the user clicks the picture, it opens a userform containg the same picture. However, I'd like that picture to be at its original size, not the scaled-down size.
how can I determine the original dimensions of a picture used in an image control? I can tell that the original resolution is there (by changing the PictureSizeMode to clip), but I can't find any properties that show me how big that image actually is, only ones that return or set the size of the object itself.
View 1 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
Aug 17, 2014
I'm using following code to delete some image called "Dev_Graph"
Sub Del_Graph()
'
' Del_Graph Macro
Sheets("Report").Unprotect Password:="1234"
ActiveSheet.Shapes.Range(Array("Dev_Graph")).Select
Selection.Delete
Range("B11").Select
Sheets("Report").Protect Password:="1234"
End Sub
the problem is, If i run this macro when there is no Image, i got a error msg.
View 3 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
Nov 17, 2009
Suppose I have a userform named myUserForm and a checkbox on it named myCheckBox. How on earth do I remove myCheckBox from myUserForm at run time? I've tried every which way I can think and I always get "error 444". Some things I've tried are:
myUserForm.Controls.Remove "myCheckBox"
myUserForm.Controls.Remove(myCheckBox)
myUserForm.Controls("myCheckBox").Remove
myUserForm.Controls.RemoveControls "myCheckBox"
I've put this in a standard module, the ThisWorkbook module, even in the myUserForm code module and each time it's the same error.
View 9 Replies
View Related
Aug 6, 2006
can i disable/remove a control from the being in the tab order.
i no i can move to the bottom but there is too many too use that option.
i need it to be elimated from user input alltogether.
it is filled automatically
View 4 Replies
View Related
Dec 11, 2013
I'm trying to delete images from an excel spreadsheet. She had imported several Red "X" symbols and placed them at the bottom of the spreadsheet so that she could click and drag them to various spots on the spreadsheet when needed.
Well, now wants several of the "X" symbols to be erased...the problem is that they won't simply delete and when I click to drag them they stay in the same place and give me a duplicate to drag.
EXCEL Example.xlsx
View 3 Replies
View Related
Oct 18, 2008
1.My macro code to insert picture from C:pictures to worksheet in colum B,but the insert pictue are very big. how can it is automatic resize with autofit in the height of the column B when i click the insert button.
2.I need some code for the delete button. if I need to delete some picture,when the delete button is clicked , the input box prompt for key in the picture name to delete. if i key in the pictue name , eg.pictue2 , so the name of pictue2 in the column A and the pictue2 in the column B is deleted.
View 2 Replies
View Related
Dec 11, 2006
I have some code to insert a picture based on the value of a cell. The user would select the name of the item by selecting the cell and then clicking a macro button.
In my code I need to delete the previous picture first. I used the following
Sub get_system_picture()
Dim pic As Shape
Dim picname As String
picname = ActiveCell.Value
On Error Resume Next
'exit sub if selection is not a system number
If IsEmpty(ActiveCell) Then
MsgBox "Please select a system number first!"
Exit Sub
End If
If Not ActiveCell.Column = 2 Then
MsgBox "Please select a system number first!"
Exit Sub
End If
The problem is this also deletes my macro button! Any suggestions?
View 9 Replies
View Related
