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 |
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 |
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 |
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