![]() |
User Form Picture
Hi
I'm trying to insert a small jpeg on a User Form in the bottom left hand corner - its about 6cm x 5cm - I can insert a picture within the VBA however its so damn big It takes over the entire user Form any ideas???? Any help much appreciated Cheers ------ Mully |
Hi
From the control toolbox, select the image control and place it on your user form in the position you want it to be. Size it to the size you want and then Right click and select properties and select the picture you wish to use. Click on the PictureSizeMode property and select fmPictureSizeModeZoom. HTH Ken |
Hi Ken
Absolutely spot on - picture in place and just finishes the job off perfectly - thanks so much - on this site in the last 4 days learnt so much from some very helpful people - thanks again. Cheers ---- mully "Ken Macksey" wrote: Hi From the control toolbox, select the image control and place it on your user form in the position you want it to be. Size it to the size you want and then Right click and select properties and select the picture you wish to use. Click on the PictureSizeMode property and select fmPictureSizeModeZoom. HTH Ken |
You are very welcome.
Ken |
All times are GMT +1. The time now is 02:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com