Display images from URL's

micmed

New Member
Joined
Feb 8, 2010
Messages
13
I have searched for this but have not seen a situation just like mine.

I have URL's in a sheet that point to images on Photobucket. Is there a simple way to have the images display in a cell adjacent to the cell with the URL?

This is a sheet with 1000's of parts items. Each item may have 1 to 10 images each.
 
Pressing the F1 key with the cursor on ScaleWidth shows the Help:
ScaleWidth Method
See AlsoApplies ToExampleSpecificsScales the width of the shape by a specified factor. For pictures and OLE objects, you can indicate whether you want to scale the shape relative to the original or the current size. Shapes other than pictures and OLE objects are always scaled relative to their current width.

expression.ScaleWidth(Factor, RelativeToOriginalSize, Scale)
expression Required. An expression that returns one of the objects in the Applies To list.

Factor Required Single. Specifies the ratio between the width of the shape after you resize it and the current or original width. For example, to make a rectangle 50 percent larger, specify 1.5 for this argument.

RelativeToOriginalSize Required MsoTriState. False to scale it relative to its current size. You can specify True for this argument only if the specified shape is a picture or an OLE object.

MsoTriState can be one of these MsoTriState constants.
msoCTrue Does not apply to this property.
msoFalse To scale it relative to its current size.
msoTriStateMixed Does not apply to this property.
msoTriStateToggle Does not apply to this property.
msoTrue Can only use this argument if the specified shape is a picture or an OLE object.

Scale Optional MsoScaleFrom. Specifies which part of the shape retains its position when the shape is scaled.

MsoScaleFrom can be one of these MsoScaleFrom constants.
msoScaleFromBottomRight
msoScaleFromMiddle
msoScaleFromTopLeft default
 
Last edited:
Upvote 0

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Forum statistics

Threads
1,217,414
Messages
6,136,480
Members
450,016
Latest member
murarj

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