1. M

    VBA - paste picture into word from path

    Hello All :) Currently I have vba code: 'Some code above If OfertomatMain.cmbUnderwriter1.Value <> "" Then For b = 2 To 20 Step 1 If OfertomatMain.cmbUnderwriter1.Value = wudoc.Cells(b, 1).Value Then Let underwriterstanowisko1 = wudoc.Cells(b, 2).Text Let...
  2. F

    Selecting pictures within highlighted cells

    Hi, I’m trying to delete a picture within a certain number of highlighted cells. I’m trying to do this in VBA and every suggested code I’ve tried doesn’t work or requires specific cells to be selected however I’m highlighting the cells via ActiveCell.Offset codes. The sort of thing I’m after...
  3. D

    Adding images in table with formatting into Outlook using a file picker

    I have pieced together some code using excel as a file picker to add images to embed within subject body. Everything is working just fine with basic alignment, but I would like to get some help adding these images into a table with a specific formatting Outlook seems not to have a huge support...
  4. S

    Looking for a VBA way to have excel rename a picture based on cell contents

    Hi I have product photos and would like vba to rename a selected photo to the cell contents. any thoughts would be great. My staff take hundreds of product photos and create the info on an item. I would like them to click a macro select the photo to rename it the model the just created. Thanks
  5. L

    Using VBA to pull images from folder to sheet

    Hello, I have a folder on my desktop with about 400 jpgs. The images are labeled with numerals like "1.jpg" "2.jpg" "3.jpg" etc. Is there a VBA function that would extract the file name and pictures and put them into an Excel worksheet? Could the cell with the picture be formatted to fit...
  6. S

    Dynamic Pictures as Data Labels in Excel Graph from Pivot Table/Slicer

    I'm trying to create a dynamic graphs based on a pivot table where slicers will be used. I'm trying to figure out a way for the data labels to be the relevant company's logo based on the slicer selections. I've figured out a way to have the labels show as dynamic to a cell, but when I select...
  7. F

    1004 Excel Cannot Paste Data (Pictures) To Workbook

    Hey All, Would you be so kind please and help me figure out why the below code only works from time to time but more often than not throws the 1004 error? All I'm trying to do is copy charts without links from one workbook to another. Sheets.Add(After:=Sheets(name1)).Name = charts...
  8. M

    After change from Picture.Insert to Shape.AddPicture picture image is shifted

    Hi, Hi I had to modify excel template VBA code to make image logo persistent outside the network so I change simple Picture.Insert(pfile) to: Set vOldShape = vSheet.Shapes(pName) If Not vOldShape Is Nothing Then vLeft = vOldShape.Left vTop = vOldShape.Top...
  9. CsJHUN

    VBA slideshow-ish

    Hi guys i would like to create a userform, which load pictures from a folder, and change the pictures every 3-4 seconds, while the user can select between 2 option button ( good or not good). And the picture name,the selected option button value would be registered below each other. The 'sleep'...
  10. S

    Userform Picture and text selection

    Good Morning, I was wondering two things, both interrelated: 1. I have a drop-down box that selects a bunch of info from an array using vlookup formulas and vba coding. Is it possible to have a collection of pictures saved on a sheet in the workbook and then the background of a userform as...
  11. M

    VBA auto-add image to cell from folder

    Dear mrExcellers, In my company we work with a product database with calculations in it, every product offcourse has an unique article number. In the shared server we have a folder with pictures of every product with the article number as the title. We want to add the pictures automatically to...
  12. E

    Import images with column names

    Hey. I had a question of exporting data from Excel to MySQL. There was an acute question with pictures. Pictures must be saved with the names that appear in the next column. How can I do that?
  13. S

    Excel Image resolution change

    Hi I have an excel file that in every row I add a picture to in one of the cells. Pictures are big and I drag them to fit in one cell then I save the file . The problem is when I open the file I want to be able to drag the picture and see the info on it but the pictures resolution has been...
  14. M

    Strange behavior for Excel 365 when deleting pictures

    I have run across some strange behavior, and am wondering if anyone else has experienced this. I have a worksheet where the user can import pictures via VBA code. I also have a couple of checkboxes (form controls) on that sheet. I have a button that allows the user to clear the sheet of all...
  15. E

    Image auto re-sized when inserted

    I am a superintendent for a construction company and I have a workbook that I am currently working on and I am fairly new to excel. It is for daily reports in which I have to add 4 pictures everyday for 6 days a week. I found that if I use a chart it will auto re-size pictures for me cutting...
  16. VBE313

    Excel Sheet Broke After UserForms With Pictures

    What is the best way to add a picture to a userform? .jpg? .gif? .png? etc.
  17. Q

    Select next picture in Excel

    I have an excel sheet containing multiple pictures with object names "Picture 1", "Picture 2", etc. The number of pictures is given by a number in cell A8 I would like to select the pictures one at a time. Currently I have Do While numpic < Range("A8").Value...
  18. muhammad susanto

    VBA : Pulling Picture From Multiple Sheets Into 1 Sheet

    hi expert.. i need vba code to collect/pull only image/photos e.g. jpg or jpeg from several sheets into 1 sheet. my data picture in sheet "hitung1,hitung2,hitung3, etc......" in cell D9 to F9.. i want that pictures can pulled into 1 sheet e.g. sheet1 in cell M2 to O2 down. The pictures must...
  19. T


    HI i am new here my name is Christy, I joined this site because i am having trouble with a particular VBA code I want to take information from cells in work sheet2 and put it into work sheet1 last row which already has 1865 rows full of information The Range from sheet1 is B1-B9, (which is a...
  20. R

    No idea how to title...Sorting in Excel to include group header?

    Hi! I'm not sure how to phrase my question which makes hard to search for an answer....Can I sort by a grouping under a heading? I have a sheet that I want to filter (by person), but I want the subheadings (Project name) to be included with the filtering. I can only explain by pictures...

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
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 "".
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