Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
#4
![]() |
|||
|
|||
![]()
You are very welcome.
Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
User Form Code | New Users to Excel | |||
opening a user form | Excel Worksheet Functions | |||
user form | Excel Discussion (Misc queries) | |||
Data Entry Alert in User Form | Excel Discussion (Misc queries) | |||
A "previous" button on a user form | Excel Discussion (Misc queries) |