displaying picture in a userform

[Todd Huttenstine]

Hey guys


In a userform I have a list of products. I need to show these pictures but
I do not want the pictures embedded in a spreadsheet. I would like to show
thumbnails in the form. What would be nice is when I click on a thumbnail,
it show a bigger picture in a new window by itself or in a large specified
area dedicated to the big picture of a current selected thumbnail.

Thanx in advance


Todd Huttenstine

 

[Robin Hammond]

Sounds like a job for an imagelist control.

There's a demo on my site that demos using this control and an imagecombo.
If you have the image files saved and use loadpicture (I think) you should
be able to get close to what you are after.

http://www.enhanceddatasystems.com/ED/Pages/ExcelFaceIDsImageList.htm

Robin Hammond
www.enhanceddatasystems.com