pic

I have a sheet called "Main" In Cell B3 I have a drop down list, Whatever I choose here I want a picture to appear on Main starting in Cell E3 I can either have the pictures stored on another Sheet or from a Folder which ever is easiest, by choice i'd like it to locate the pic from another...

** RESOLVED with Resume ResumeCode under "rngPicPosition = "IMAGE UNAVAILABLE"" Hi, I'm trying to import a picture using an URL, if the picture isn't found then go to my Error Handling code. Which works fine on the first loop but then fails on the 2nd +. Any suggestions? I'm 100% sure it's...

Hello Excel Gurus, To start off I am learning macro as I go. But here goes to what I am trying to do for this macro. I have a tab lets say "Sheet1" where there is two columns of data A:B. Column B has hyperlinks to PDF's. Then I have "Sheet2" where I have cell B2 where someone can enter in a...

Hi, I have the following code that pastes an image from a URL into a cell where rngPicPosition is variable, it changes for each loop in my full code so first loop is .cells(5,3) next loop is .cells(10,3).. .cells(10,5) however it's pasting the image into the activecell. Any ideas why? I'm...

Hi, I created a macro that will pull an image from a URL and then save it into my directory via PowerPoint. Before the macro I was manually getting the pictures and using the save macro after that which worked fine but now with this pull URL I'm suddenly getting this message. How do I prevent...

hi guys.. i need your help, this code not stable i have modify this code in the other sheet but still error.. here this code : Sub Test2()<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">Dim indx As Long Dim cellFrames As Variant Dim Pic As...

What I want to do is have a Yes or No under the Eligible Superstar column (first pic), using the names on the second pic. So if the name in A3 of the first pic is on the list in the second pic, then Yes in G3, if the name isnt on the list, then No in G3. Is this possible? Thanks

Fellow sufferers My below code stalls somewhere between Debug.Print "Inserting pic from URL " & strShpUrl and Debug.Print "Inserted pic from URL " & strShpUrl. I am new to errorhandling, I tried to read everything there is, so whats wrong with my code? The sub should be run about 300 times to...

hi guys.. i need your help .. i have extract/insert picture 4 pic from a folder in cell then i want that 4 pic can automatically resize and placed in cell star row from 84 to 87 (4 box cell) my arrow i hope can be explain.. this my file : https://app.box.com/s/via1y8c2asfabjbltwqmyjxujlxbx2x9...

Hi guys, I'm trying to create a Macro to delete all the pictures contained in the selected (highlighted) cells. The macro has to be used several times and in different Excel files consequently the cell's references change every time. I created the below macro but it does not work unless I...

Dear Experts Hi, I need your guidance regarding showing related images, 1. In drive D I have a folder name Database 2. One of Subfolder exists here is named Images (contains lots of images named by ID, 11,12,13 etc.) 3. An Excel Workbook exists here in the database folder 4. One of worksheet...