image

I am stacked with this code and I need someone to fix a few bugs for me. I have observed that when I cancel the dialogue box, then the workbook starts to behave some weird way. For instance, there is an image control on one of my worksheets that I load an image to from a userform – it fails to...

Is there a way to have all the text in a worksheet print in black, so that I can still have a color image print in color? I cannot choose the print black and white option in page setup because it turns the image black and white too. I am trying to figure out a way for users to easily identify...

can someone help me why my userform's background image in my pc is llooking good but when i run it to my friend's pc the background image of the multipages will become small..

I have 2 images stored on a sheet in my workbook. I need to be able to copy them and put one in the header and one in the footer. Can anyone help me with the vba code please?

I'm using the following code to display an image in a workbook. Sub Image21() On Error GoTo ProcExit21 Dim objPicture As Picture With Sheets("Working").Cells(1, 1) ' Picture displays in cell from row, column Set objPicture = .Parent.Pictures.Insert(Sheets("Working").Cells(2...

I have code to insert a set image. Could someone tell me how to alter it so it can insert a custom image please? Sub cmdJakeSig() Dim shp As Shape Set shp = ThisWorkbook.Worksheets("sheet1").Shapes("textbox4") Sheets("Sheet2").Shapes("ImgJ").Copy Sheets("sheet1").Paste...

I have a button that inserts a signature at the bottom of a sheet under the last row but if the rows are nearing the bottom of the page, the signature image will be pasted half on one page and half on the next page. Here is the code to paste a set signature and code to paste a custom signature...

Hi All, I'm after a macro that will loop through all the rows in column A on an excel spreadsheet and create a powerpoint slide for each one and put the value from the cell on the slide and insert an image according to a specified filepath in column B. E.g. Create a slide tittle "Apple" from...

I am making progress. At the moment I can add an image to a cell, size it to a specific range but thats where I am stuck. Now I would like to be able to select an image in a specific range and change the background colour (white) to transparent. Any ideas? My attempt is in red below...

Using the following URL in cell S2: https://www.tesco.com/groceries/en-GB/shop/fresh-food/fresh-fruit/bananas I am trying to pull all the image Src URL's on the page. Any ideas why this isn't quite correct please? Thanks. Sub Images() Dim XMLPage As New MSXML2.XMLHTTP60 Dim HTMLDoc As New...

The challenge gets tougher and I have to call on Tech support:) When I click on a command button, I want to access the open dialogue box where I select an image file from a folder - this could be anywhere on the computer. Then I rename that image with the content in textbox1 (for example)...

I don't know how to say, so look at the image: https://www.dropbox.com/s/rmejl7f0xif7cmb/excel.png?dl=0 Read the text on image. If skills are selected below with any character (for image i used "x" below "passing"), then cells in table below with the same text have yellow background. So i...

I have code that puts an image in the right spot. Could someone help me with the code that allows you to insert your own image and put it in the same spot please? This is the code that puts the set image in the right spot. Sub cmdGarrettSig() Dim shp As Shape Set shp =...

When I enter the textbox, I want to store its content to a variable "MyEnter". Then when I change the content I store the changed content to " MyChange". Then inside a folder , "MyPics", located at the location of the workbook, if there is an image file called same as the content of the "...

I have my spreadsheet set up so on Sheet2 there are 2 columns of titles and the 3rd column is an empty cell. Next to this empty cell is a button that the user can click, a file browser opens up, and they can choose an image. Selecting an image will insert the file path into the cell and insert...

Hi everyone, Hopefully an easy one for someone to help me with. Can anyone supply the VBA to insert an image from file into a selected shape this is what the recorder gave me. I would like the user to be able to choose an image from file and not restrict them to a pre-defined name. Sub...

Hi All I have a sheet where all the rows have a product image. There are quite a few rows so loads of images - all thumbnail size. However, the user often needs to duplicate the sheet in other tabs, so in theory all the images are copied too and my file size gets bigger and bigger! Is there a...

I have data validation set up allowing a range of cells to only accept whole numbers between 0 and 100. I currently have a bland error message that pops up if the user enters data that doesn't fit the criteria. However, I want to add a picture instead of some text. Is that possible at all...

What up?

I have been working on a workbook on my laptop the last couple of weeks. One of the things I did was insert an image file into a UserForm. I figured out the exact resolution the image file needed to be in order to look right within the UserForm, and then input it as an image control...