picture

Hi I've been working on that code with GPT usage. I tried to find the solution but any change to the code doesn't let me insert photo to a cell. The photo is floating on the sheet Sub SelectSheetAndPasteValue() Dim sheet As Worksheet Dim selectedSheet As String Dim employeeNumber As...

Likely a tough one here. Simplifying a complex worksheet here. But basically: A1 = Value A2 = Value A3 = Value A4 = Value A5 = Picture based on A1:A4 values. Limitations: Pictures have to be referenced from within the excel Workbook. Not external to a referenced folder or website. I can...

Hello everyone! I was working in a macro where it will insert for me pictures from my C drive, however, I need to exchange the code to insert the same pictures from a workspace or SharePoint or website. I have tried but I was not success. please I need your help. this is the image address"...

On my Userform, several CommandButtons have pictures instead of text, using Me.btnSave.Caption = "" Me.btnSave.Picture = LoadPicture(btnDir & "Save.gif") Which yields a userform with colorful icons: When disabling the CommandButtons, using Me.btnSave.Enabled = False the buttons become...

Hi! I would like some help in order to change the range of action of a paste picture macro I would like to paste photo in range: - L17:U17 based on the value from L3:U3 - L40:U40 based on the value from L27:U27 - L63:U63 based on the value from L50:U50 - L86:U86 based on the value from L73:U73...

I have a report that needs pictures imported regularly. I have a Macro that will delete the pictures in a column and then import new ones. However, using the button back to back will eventually give an error of "1004 Unable to get TOPLEFTCELL properly of picture class." Is there a way to...

Dear all, I hope you can help me with an issue I have. I had a perfect working piece of code that fetches an online picture (value in cell) and posted this in certain file. Never had any issues. Since December it gives me the 1004-error "Unable to get the insert property of the picture class"...

Estimated forum members, I've created the following macro to generate an outlook email and turn ranges into pictures before pasting them in the mail's body. The thing is that from time to time (approx. 1 out of 5 attempts), it results in an error message 'Error 13, Type mismatch'. If said...

Hello all! I have been reading posts here and online and i'm not sure which path to try. I have a Userform with many buttons that lead to various "Orderforms" - 1 per vendor. What my macro does is capture the info from each vendor onto 1 "Summary" Sheet and 1 "customer info" sheet. (I guess...

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

Hi all, I have two sheets. Sheet 1 (“Overview”) contains raw data, Sheet 2 (“Charts”) contain XY plots. On sheet 1, I have a table with four columns. 1) Company, 2) Industry, 3) Metric one, 4) Metric two. Based on filters applied to the industry-column, I’d like the XY plot to automatically...

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

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

Hi everyone! I ran into some trouble trying to open the insert picture from file dialog box when double clicking a specific cell and then inserting the selected picture into the double clicked cell. I was able to get a basic code working where if you double click a cell in a range, then gives...

Hi, wondering if there is VBA to email charts and data in a range that can vary. And also photos with text below. I've tried a few things but I've had no luck. Below is my code for email, but pictures don't get sent. Sub CDO_MTD_BY_VENDOR() Dim rng As Range Dim iMsg As Object Dim...

Good morning everyone, I am making a new sheet to use at work so that multiple users can record any errors or issues on the production floor into a "log" that can be referenced later. Filling out the text cells and having them transfer, NO ISSUES whatsoever. Something I'm trying to implement is...

Hi, Below is my VBA code to grab a jpg picture from the web. Currently it inserts it CENTRED, how can I justify it to the RIGHT? Sub URLPictureInsert() Call delete_picture Dim Pshp As Shape Dim xRg As Range Dim xCol As Long On Error Resume Next Application.ScreenUpdating =...

This code is driving me insane. I have created a macro that is structured as below. It creates a chart based, copies it from an Excel Chart tab and pastespecials it into word. Creates a page break, clears the clipboard and does it again for a total of around 100 times. Please see the below...

Hi, I have around 250 sheets in a workbook all with a unique sheet name. I have 250 unique pictures (custom border templates) that correspond to the sheet name which I would like to insert into the header. How could I do this without manually going into each sheet inserting the picture and...

Hi everyone, I've inserted pictures into my spreadsheet using the code below. I want to keep the aspect ratio, and have the top left of the picture starting from cell H20. It works fine with most. However a few pics instead of sitting nicely in that corner, they just float randomly (to the...