ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Usin Picture on userform (https://www.excelbanter.com/excel-programming/324584-usin-picture-userform.html)

Momo

Usin Picture on userform
 
Hello,

I am creating some userforms and just wondered if someone could tell me if i
put a picture box on the userform, how do i get a picture on it?

Some sample code or explanation would be useful,

Thanks
Andy

Bob Phillips[_6_]

Usin Picture on userform
 
There is an image control that you can load a picture into.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Momo" wrote in message
...
Hello,

I am creating some userforms and just wondered if someone could tell me if

i
put a picture box on the userform, how do i get a picture on it?

Some sample code or explanation would be useful,

Thanks
Andy




Glenn Ray[_3_]

Usin Picture on userform
 
Andy,

After you insert the image box, look at the properties. There are three
properties you'll be using:

1) Pictu It will be "(None)" by default. Click in the Properties cell,
then click the ellipsys button ("..."). You will see a Load Picture dialog
box. Browse until you find your image and then click the "Open" button.

2) PictureAlignment: This determines where the picture is anchored within
your image box.

3) PictureSizeMode: This determines the scaling used:
fmPictureSizeModeClip - Image is loaded into the box at 100%
fmPictureSizeModeStretch - Image is loaded to fit the full dimensions of
the image box
fmPictureSizeModeZoom - Image is loaded to fit the largest dimension of
the image box without changing its aspect ratio.

-Glenn Ray
MOS Master

"Momo" wrote:

Hello,

I am creating some userforms and just wondered if someone could tell me if i
put a picture box on the userform, how do i get a picture on it?

Some sample code or explanation would be useful,

Thanks
Andy


Momo

Usin Picture on userform
 
Thanks all

"Glenn Ray" wrote:

Andy,

After you insert the image box, look at the properties. There are three
properties you'll be using:

1) Pictu It will be "(None)" by default. Click in the Properties cell,
then click the ellipsys button ("..."). You will see a Load Picture dialog
box. Browse until you find your image and then click the "Open" button.

2) PictureAlignment: This determines where the picture is anchored within
your image box.

3) PictureSizeMode: This determines the scaling used:
fmPictureSizeModeClip - Image is loaded into the box at 100%
fmPictureSizeModeStretch - Image is loaded to fit the full dimensions of
the image box
fmPictureSizeModeZoom - Image is loaded to fit the largest dimension of
the image box without changing its aspect ratio.

-Glenn Ray
MOS Master

"Momo" wrote:

Hello,

I am creating some userforms and just wondered if someone could tell me if i
put a picture box on the userform, how do i get a picture on it?

Some sample code or explanation would be useful,

Thanks
Andy



All times are GMT +1. The time now is 09:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com