.width

I am making progress. At the moment I can add an image to a cell, size it to a specific range but thats where I am stuck. Now I would like to be able to select an image in a specific range and change the background colour (white) to transparent. Any ideas? My attempt is in red below...

hi all.. i found macro code to resize picture in Excel... here this code : <tbody> Public Sub FitPic() On Error GoTo NOT_SHAPE Dim PicWtoHRatio As Single Dim CellWtoHRatio As Single With Selection PicWtoHRatio = .Width / .Height End With With Selection.TopLeftCell...

Hi All, I have the below code to insert images into my worksheet from a URL; however, it doesn't save the image with the workbook/worksheet - I need the code modified below so that it saves the actual image with the worksheet and displays it if I share the file with someone else. Help! :)...

Hi, I have some code which takes a range in excel (which changes in size) and then pastes it into powerpoint as a picture. I need some code that will copy the range and paste it as a picture to a specified width or height (one or the other). Whether the picture is sized to the specified width or...

Hi All I have had some help with another user on how to create a button whereby I could open a popup, select a picture, have it stretched to fix and centered in a cell. However, i just noticed that if there was an existing picture there, it would not be deleted, and the new picture that i...

Hi all, I've been using the below macro to fit pics into the cell which they reside in. It's working fine if I select one pic at a time but fails for more than one. I would like to save more time by making it applicable to all selected pictures to fit (and aligned) in the cell which they...

I am having some trouble adapting a code I found online to list all the modules for open workbooks. The code works great but if there are a lot of modules then the UserForm box becomes so large I can't see the buttons on the bottom. I want to add a scrollbar to it so the UserForm can stay the...

Hoping you can help troubleshoot what part of my code is causing it to hiccup. This procedure will be called from another, and is intended to make identical changes (i.e. add several Comment boxes) on various sheets within each workbook in the user-selected network folder. It has run...

I have a userform that shows or hides different controls based on what is selected from ListBox1. It also adjusts the left and top values of the appropriate controls depending on that selection, just to make everything look good. So upon initialization it sets the left and top values of each...

hi all... i'm looking vba code to insert multiple picture into cell (auto fit) ... this code below running only 1 picture, i want the code work in multiple pictures /images.. how to modify it ? Public Sub FitPic()On Error GoTo NOT_SHAPE Dim PicWtoHRatio As Single Dim CellWtoHRatio As Single...