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

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
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,214,978
Messages
6,122,545
Members
449,089
Latest member
davidcom

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