image

  1. 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?
  2. 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...
  3. 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...
  4. A

    VBA to copy and paste image from a folder to another folder

    Hi everyone, I want a button in Excel that allows user to choose an image in their personal drive, through browsing the file location. Once they select the photo, it should create and save a copy of this photo into a shared folder, then put the new file path of the image into a cell. (This new...
  5. M

    How to view an item Image in a Userform from a saved Image Folder

    I have a workbook that has 1500 itmes as inventory and items going out and coming in everyday. I have a userform which i have bult to manage this with ease all items linked to an itemcode. I would like to display the item image as well in the same userform when item is recalled by item code...
  6. W

    Userform picture based on a combobox selection

    Good morning all, I've seen a few posts on here but haven't found a situation similar. On Sheet1, I have a list of all employees. On a local drive I have a picture of all employees which I would like to hyperlink to the name...that's the easy part. My userform has a combobox that's populated...
  7. L

    VBA: Hyperlink to image placed in comment, multiple sheets

    Hi, I am struggling to make a hyperlink into a picture into a comment. I am exporting checklists to excel where the user has to take pictures for some of the checkpoints, and when I export them, they appear as hyperlinks in excel. Now, I want to transform these hyperlinks into images placed in...
  8. A

    Display image using Name Manager on a dynamic spilled range

    Hi all. I am new here, so apologies if I miss any conventions with making this post. I'm using Office 365, on Windows. Here is a link to a screen-recording of the spreadsheet/dashboard. (Unfortunately the screen-recording does not capture the drop-down list, for some reason, but you can clearly...
  9. O

    Code to delete unused cropped region

    Hi there, My goal is to delete the cropped space of images that is currently unused. That is, after an image has been cropped, I want to use "compress picture" function in excel/word/powerpoint to batch process this over multiple files. My problem is that I can do this just fine in excel...
  10. H

    vba little change in code (entire workbook replace with one sheet in code)

    hi dears i have this 2 macro for excel to jpg convert and work perfectly , but my workbook have 10 sheets and i must repeat this code for every sheets . i need change these codes macro a : 1-for do it for entire workbook automativally and with no question 2-every export jpg file name is same...
  11. J

    Image scale to fit on userform

    Hi, I have a large area on my userform which I want an image to occupy. The image which is inserted is based on a CB selection. However, when the image is inserted, its always much smaller than the pre-determined area. I know I can scale the image area to fit the smaller image, but is there a...
  12. M

    copying images from one folder and pasting in another based on schedule in excel file

    Hi guys Hope you all well and safe from Covid. while in lockdown im hoping someone can assist me with this query. i had a macro created whereby image product code is listed in Column A, Column B lists the location of that particular image and Column C displays the location of where i want...
  13. M

    Macro to pull multiple images from folder to multiple sheets by image/sheet name

    Hello all, happy to be a new member here and looking forward to becoming an active member of the community. Here's my problem: I have a workbook that contains 230 sheets which are essentially forms that are pulling data from the first master sheet. Each sheet is named after a specific...
  14. H

    Using Macros to "Change picture"

    Hi All, I need to make several hundred excel files which all have the same layout with different information (I.D. Cards). I have resolved all time consuming issues except manually changing the picture for each person. My idea is to write a macro and assign to a button that does the same thing...
  15. D

    Add every file inside a folder

    Hello, I'm trying to do a macro that let's the user select a folder with more folders inside, this folders could have images .jpg or .png. What I want is that the macro adds only the image files in the excel, any image file. What it does right now is that adds the images but only if they have...
  16. M

    Function does'nt work !!

    Hi, After many researches, I used this function to convert my images path into format BASE64. Public Function EncodeFile(strPicPath As String) As String Const adTypeBinary = 1 ' Binary file is encoded ' Variables for encoding Dim objXML Dim objDocElem ' Variable...
  17. Y

    Error in code to save loaded pictures in userform to specific path

    Hello, I have the following code that I got with the help of this wonderful forum. I have modified a little but it is not working. Would it be possible to get your help? Private Sub PicToSheet1(picControl, sht As Worksheet) Dim PCAR As String CAR = Me.TextBox1.Value Dim p As String...
  18. Y

    Copy image in userform to a worksheet

    Hi, Would it be possible to have your help to get a code that allows to copy an image loaded in a user form to worksheet 4 in cells A12:N12 and M12:BL12? I have the below code but I do not know how to make it work for the range of cells where I need to insert the pictures. I would appreciate...
  19. G

    Screen Refresh

    On one worksheet I have a group of buttons (not actually grouped, but just adjacent). When I click one of the buttons is unhides another worksheet and hides the first worksheet. The buttons show as an image on the second worksheet and the real buttons on the second worksheet are not visible...
  20. Z

    Image Click event

    Hello People, I'm trying to figure out a code which perform this : clicking on a image to open a certain form. I tried using this DoCmd.OpenForm "NameOfForm", , , "Image1=" & Image where Image 1 is the name of the image that i want to click on to open the form. any ideas ?

Watch MrExcel Video

This Week's Hot Topics

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
Top