Resize and save picture / class module

**onlinecom** · 04-06-2011, 05:29 PM

I need resize picture in user form and save on to hard drive on my computer. Do you know any class module.

Any help will appreciate.

Thanks.

**Leith Ross** · 04-06-2011, 05:42 PM

Hello onlinecom,

Welcome to the Forum!

Is the "user form" a worksheet or a VBA UserForm?

**onlinecom** · 04-06-2011, 06:09 PM

Hello Leith Ross,

This is user form in visual basic editor.

**Leith Ross** · 04-06-2011, 10:50 PM

Hello onlinecom,

I should have asked you these questions earlier.

Is the picture assigned to the Picture property of the UserForm already or does it need to be loaded from the hard disk?
Does the picture need to resized to fit the UserForm?
Did you want to save a copy of the resized picture to the hard disk?
Do you have a sample workbook you can post for review?

**onlinecom** · 04-07-2011, 04:36 PM

Hello Leith Ross,

1. Picture need to be load from the hard disk. If possible "drag and drop"
2. Picture doesn't need to resized to fit the UserForm. Just resize and save to hard disc.
During resazing should also rename picture like just numbers example picture no1, no2, no3 ..... and that name of the picture should be saved in to columns in excel sheet
3. Yes, I want to save resized copy of the picture on hard disc example in c:\resizedpictures
4. I don't have any samples

I appreciate that you helping me very much.