.width

  1. A

    Insert Size Shape and Transparent Background Image

    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...
  2. muhammad susanto

    VBA : Resize 2 Pictures in Specific Range (G13 & D13) Wtih Simultaneously

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

    Insert Image from URL - Save Image with Workbook

    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! :)...
  4. C

    VBA to paste picture into PPT to a designated width or height whilst keeping aspect ratio

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

    VBA to Delete a picture before adding one to target cell

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

    Fit all selected pictures to cell size - vba macro

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

    Userform sizing

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

    VBA question for .AddComment in With statement

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

    Any ideas? UserForm Initialization doing funny things.

    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...
  10. muhammad susanto

    Vba : Insert Multiple Picture Into Cell (Auto Fit)!! Working Only 1 Picture

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

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
Back
Top