images

mhobbs

New Member
Joined
Dec 10, 2010
Messages
21
How do you insert an image into a userform? Also once the image is in the userform how do you move it around?

Cheers,

Marland
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
do you want to insert while the program is running or just have it there all the time
 
Upvote 0
I want the image to be there all of the time. To be part of the userform when the program is running.

Thanks
 
Upvote 0
2 choices:
if the image covers the whole userform (a background) thenif you click on the title bar of the userform, you will notice that there is a property called

Picture (none)

click on the (none) bit and choose your picture
it can be controlled by the properties PictureSizeMode and PictureAllignment


second choice: a picture in a particular spot on the form.
use the image tool to draw the frame into which the picture will go and do as above.
 
Upvote 0
Open VBA Editor and then Go to View Menu then Select Project Explorer,
then select Your User form on which you want to add picture, See Left opened Window Select Categorized Tab Then Go Picture Tab Then Brows the picture location then You can get it on >>>>>>>>>
 
Upvote 0

Forum statistics

Threads
1,215,472
Messages
6,125,003
Members
449,203
Latest member
Daymo66

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top