Populate Images on Userform Image

Hi All

i gone through google and i am unable to find the correct solution for my query.

My query is, I have 100's of image and its extension is ".tif" and each image contains approxmaitely 5 to 10 and its not constant.

and i want a text box there i will enter the number of image and that image should show on userform load image right down to that i want a label , that lable should show that image contains how many sub images and similarly i want next & previous button , when i click on next button then next page should show of that number only

suppose i have enter this nbr : 999 and i hit show button then image will load on userform and in label caption will show 1 of 5 , next i will click on next button then label should show 2 of 5 and same time next image should dispaly

hope i explained my query in understandable manner.

Note: Sorry , but i cant attached the images its contain official information.

What you want to do isn't simple. Tifs are not natively supported, so you need to do some hacking around. Here's what I came up with, it requires far more resilience and testing but may serve as a proof of concept.
Userform Code:

Please Login or Register  to view this content.

Module:

Please Login or Register  to view this content.

Hi Kyle

thanks for quick response, the solution u provide that extremely very nice i appreciate

but that macro opening the windows image viewer, however i want the image should show on userform image event there only i can zoom in and zoom out and scroll up & down.

So if possible can u look for this way, if its possible then its really extemely awesome ! , mean while i will use this macro.

Once again thanks & waiting for your another reply....

as of now i didnt test with the original Image files because that file there with my collegue.

Is that a yes or a no? I'm not sure what you mean