insert picture on worksheet to userform

I am developing a userform for someone. I have some pictures i want to display on the userform

Instead of using pic = c:document/picure/image

I want to save the pics on sheet2.

I also want to have a next button to view the pics.

when the form load it will load with pic1 when the next button is click it will move to pic2 and when it is click a third time move to pic3 and so on.

thanks

You should be able to do this with a Userform control "Image List" or Just load all you images on the Userform in seperate "Image" controls and make each one visible as required.

thank for your reply

I decided to use the imagelist control however I am not sure which property to use to assign

to get it to display in the image picture.


Image1.Picture = ImageList1.

In your Userform you need an "ImageList" control, an "Image" Control and a "CommandButton"
In design mode with the Userform control showing in the code window, Right click the "Imagelist" control and select properties.

In the properties list you will see near the top "Custom", click the dropdown list and the "Properties" page appears, click "Images" then Insert Picture as required.
Repeat to load all our Pictures.

Load the Code below into your Commandbutton.
Make sure Option Explicit and Dim c as integer are at the top above "Private Sub CommandButton ---"

Please Login or Register  to view this content.

Now when you show the Userform, you should be able to Show each picture in turn on Clicking of "CommanButton .