image

  1. A

    Image with IF Condition

    Is it possible that if a specific cell is blank then the desired cell should be blank and if specific cell is not blank then the desired cell should display a picture. I am having such a situation in my result card. I wish if result card shows the "Pass" or "Fail" Status only then the next cell...
  2. T

    Image object

    I'm trying to add an image into an email in vba. I've inserted the image into a sheet as I couldn't get the file location method to work. Here's my code for the relevant section in the email body: EmailBody = HelperSheet.Shapes.Range(Array("Picture 2")) It's highlighting the whole row and...
  3. T

    Using an if statement to add an attachment to an email

    I need to use an if statement to add an attachment to an email if cell G5 contains specific text (e.g. "Specific Text"). I've tried using If Range("G5").Value = "Specific Text" Then .Attachment.Add "C:\Documents\MadeUpFileLocation\ImageName.JPG" End If but the debug is highlighting the...
  4. T

    VBA Put a button in the background on a PDF

    Hello, following discussion on this post: https://www.mrexcel.com/board/threads/vba-to-place-images-inside-a-pdf.1172893/#post-5704893 The code allows me to add a button with an image. But I would like to be able to use the dynamic fields of the PDF. Off the button is in the foreground...
  5. M

    Macro Fit a image in a cell acording to his size.

    As this is my first message here and I don't see any place to make it, i Want to say Hello word and thanks for the amazing job all you are doing for teaching us. I have a question with a macro that works well, but I can't adapt it to improve what I want. I have a book that the first sheet is...
  6. J

    Replace Drop Down List Arrow with Image/Shape

    Is there a way to change the box/arrow attached to a drop down list, to an image/shape? Basically, instead of clicking on the arrow & box to activate a drop down list, there's a small image or shape that can be clicked. Same functionality as the regular drop down list, just change how it's...
  7. D

    Inserting an image based on the content of the adjacent cell

    I have a list of zip codes in a verticle column (A32:A200) on a sheet Named "Formulas". I have an image named "Bolt" in cell C4 on a sheet, named "New Job Log". Also on that New Job Log sheet, I have two non adjacent columns. On the left, starting at C5 is an empty column of cells. On the...
  8. N

    Releasing memory while adding new images

    Maybe a silly topic, but I'm still novice and quite unsure about some details. I have a Userform. Left side column has the menu, consisting of 7 options/"buttons". Those buttons are actually images which change when their area is hovered. E.g. they are originally blue, the hovered state is...
  9. N

    VBA - Userform & Image size issue

    Hello everybody, I have a userform, for which I have specified the (Height = 720) & (Width = 1280) properties from the Properties panel. And I have made a Jpeg in Photoshop which is intended as a sidebar menu background in my userform and it's (Height = 720) and (Width = 190) Now, one would...
  10. A

    Post shape from spreadhseet into correct position of html email created in vba

    Hi, I am trying to create an email in outlook using VBA. In the email i want to include text and a formatted table from the spreadhseet. In addition i want to add an image/shape to the BOTTOM of the email, but I can't seem to get it to land there. Here is the code i have managed to put...
  11. B

    Worksheet_SelectionChange event not firing !?!

    Hi all, Worksheet_SelectionChange event doesn't fire if I change the selection from a cell to an image. Does it only fire if a cell is selected (it seems to be the case, but I thought I'd check)? Option Explicit Private Sub Worksheet_Activate() Application.EnableEvents = True End Sub...
  12. B

    How to deselect and fire a click event for images laid dynamically on a sheet

    Hi all, I have a program that inserts various square images onto the same size cells, on one particular sheet. From the code on a form, I want to disable all the images, to remove the grab points thus obviously preventing them from being moved, resized, etc. I also want to be able to click...
  13. E

    Simulate a slideshow - image changes on click

    I have a spreadsheet with tons of images and have to demo said spreadsheet to clients. Instead of scrolling and scrolling and scrolling, is there a way to click a button, or use a dropdown to change (load/remove/replace) and image? I would prefer to load the image from my desktop, rather than...
  14. D

    Importing images from folders into corresponding cells in the worksheet

    Hello. I need a macro that I have no idea how to even start making. I have multiple images in multiple subfolders. The file structure looks like this: /Excel_file.xlsm /Images/Object1/Image1-1.jpg /Images/Object1/Image1-2.jpg [...] /Images/Object2/Image2-1.jpg /Images/Object2/Image2-2.jpg [...]...
  15. W

    Convert .jpg files to PDF

    Hello, I currently have thousands of folders with each of them having up to 10 .jpg image in them. My goal is to create a macro that goes over all folders, and for each of them, converts all .jpg files inside it into one PDF (1 img/page). I have successfully made the macro for one folder, so...
  16. S

    Excel lookup images, through VBA.

    Hi, I'm looking for a way to have my buyers take photos and have Excel look in a folder for the photos. Below is an example of current code i use. But I would like a quicker way to have Excel look for a photo. To code this for 200 photos would take a long time. The product for it to look up...
  17. J

    Opening a image within excel

    I have an excel file which lists the stamp sets that I have. This catalogue is used to locate a particular stamp. I want to be able to open an image file associated with that stamp set. I am using the "insert link" function. This works after a fashion ... ie: it works only for that...
  18. K

    Set image as excel sheet background

    as you can see i have an image as a background in excel but this image has been converted as if it becomes the sheet itself, thus allowing to select cells just above the image itself, can someone tell me how to do this in another image?
  19. D

    VBA Copy range as image has low resolution?

    I have some VBA code that finds named ranges throughout a workbook and saves those ranges as images. The code works great, but the resolution of the images is not that great. If you do a manual screen capture of the range and put that image next to the image created from the macro, there is a...
  20. J

    Dynamically move linked pictures, to avoid overlaps / blank gaps between them

    Hey everyone, I was hoping someone could help with some ideas. I have an Excel report with multiple linked pictures, one after another in a vertical layout. Each of these linked pictures points to a named range, and each of these named ranges points to a specific pivot table. Some of these...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top