-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
aspect
-
U
Can we scroll through images and change the aspect ratio in a UserForm?
I need to be able to select between windows used in home remolding. I have several GIF images that I would like to scroll through and I want to use their file names in the bill of material. I also want to know if there is a way to change the aspect ratio based on the window's dimensions. My...- USAMax
- Thread
- aspect images ratio scroll windows
- Replies: 2
- Forum: Excel Questions
-
V
VBA to Crop Image to 1:1 Aspect Ratio
Hello, I am attempting to use VBA to crop images to a 1:1 aspect ratio. Here is the code that I am using currently: With shp Width = .Width Height = .Height TCrop = Width - Height Hcrop = TCrop / 2 End With With .PictureFormat .CropLeft = Hcrop .CropTop = 0 .CropBottom = 0 .CropRight = Hcrop...- ViperDriver35
- Thread
- aspect aspect ratio crop end vba
- Replies: 4
- Forum: Excel Questions
-
V
Help cropping image to 1:1 Aspect Ratio
Hello, I have searched the internet and these forums pretty extensively trying to come up with an answer to my question. Essentially, I am trying to take an image with an aspect ratio other than 1:1 and crop it to an 8 inch by 8 inch size. I have found that 72 points should correspond to 1...- ViperDriver35
- Thread
- aspect aspect ratio crop image vba
- Replies: 6
- Forum: Excel Questions
-
E
Joining And with Or in an If Statement
Hi All, The below code was working perfectly, however I want to add an extension to the formula to check that the football column = "yes" and the sport column = either "1" or "2" then I want "no" returned, otherwise go on to the next aspect of the formula. =IF(Football_Column="Yes","12...- Excel_77
- Thread
- =iffootball_column=yes aspect column formula sport
- Replies: 3
- Forum: Excel Questions
-
G
dynamically display pictures
Greetings to you all. I have a workbook with list of clients and their details in sheet (index), while every client has a sheet each, on every sheet i want picture of every client to appear on his/her. i got the below code online, but it only works if the sheets were un-protected, and i need...- gleamng
- Thread
- aspect dim end pictureheight single
- Replies: 1
- Forum: Excel Questions
-
A
shapes.addpicture aspect ratio
Hi to all i am using the below code to insert a picture in excel. the code works and i get a picture, but i how like to size the picture to a fixe width and maintain the aspect ratio. Any good suggestions.? Worksheets("Approval Drawing 1").Shapes.AddPicture _ Filename:=myDir &...- akashawalker
- Thread
- aspect code picture ratio t_1
- Replies: 3
- Forum: Excel Questions
-
U
Excel Superhero : Aspect Ratio of Images - Does not lock on print : Solution possible? (2016 / 2013)
I've looked through different posts but do not see a solution to this question that seems to have plagued Excel since day 1. All I would like to do is insert an image (our logo... simple jpeg... see images below) into a spreadsheet. I do and it looks great. I lock the aspect ratio. Then when...- utilichoice
- Thread
- aspect image print ratio stretched
- Replies: 2
- Forum: Excel Questions
