Import And Resize Images

[2eXtreme]

How can i import and resize an image that is stored on my harddrive
into an excel spreadsheet. I want the user to be able to select th
image name from a drop down box, and then press an import button. Whe
this is pressed, the image will be imported into the spreadsheet and
user form will appear asking the user to enter new attributes, i.e
width and height. Is this possible

 

[2eXtreme]

Please help!

 

[2eXtreme]

anyone?...

 

[2eXtreme]

*bump*.......

 

[Dave Peterson]

You could build a userform and get all that information, but why not let the
user resize the image after it's imported. As a user I would find it much
easier to grab a corner of a picture and resize to what I want than to have to
type in numbers that may not mean too much to me.

And as a personal preference, I think I would rather have users clicking on
Insert|Picture than running a specific macro that accomplishes the same thing.

But if you want, this might be enough of a macro to insert the picture--no
userform, though:

Option Explicit
Sub testme()
Application.Dialogs(xlDialogInsertPicture).Show
End Sub