VBA UserForms (Excel 2000)

Topic

New Reply

Does anyone know how to size a picture on a UserForm? I’m trying to put our logo onto a dialog box I’ve created and it’s HUGE. I can’t figure out how to make it smaller since there are no sizing handles as there are with pictures in a spreadsheet.

Thanks in advance,

Christa

Reply | Quote

Replies

Probably your best bet is to load the logo into MS Photo Editor or some similar bitmap editor (assuming it is a bitmap) and re-size it there. The size is often determined by the dpi (dots per inch), so the first thing you could could is to reduce that to 96dpi (that is the normal for screen display), and if that does not reduce the dimensions enough, you can resize the picture dimensions in the bitmap editor.

Reszising the source image is the best as it will reduce the size of your project.

Hope that helps

Andrew C

Reply | Quote

Thanks, Andrew…I appreciate the help

Reply | Quote

Andrew is correct about including a large picture in your project.

However, if you have something that is around the same size, and you only want to make small changes (or if you want to make a picture larger), set the PictureSizeMode propert on the image control. By default, it’s set to 0, which doesn’t allow resizing.

Reply | Quote