vba web control gif image disappearing when changing tab on multipage

Formula:

Please Login or Register  to view this content.

Hello,

I have this formula input on userform initialize and its loading my web controls great with gif images.

They are placed on separate tabs on a multipage object with tabs.

However, if I leave a tab and then go back to it.. my image is now gone.

Any ideas why or can someone tell me where to put code to refresh them?

Kind Regards,

KAZ

Hi,

Thanks for the reply.

Yes the images are saved on my hard drive.

They are being loaded into a microsoft web control found in additional tools when right clicking on toolbox.

The excel form picks them up as long as they are in the same directory and called web1.gif and web2.gif

I have deleted all stuff not needed from my project as to provide a sample.

Please find attached a sample. Form is called frmmain

web1.gif can be downloaded here https://dl.dropbox.com/u/80622831/web1.gif
web2.gif can be downloaded here https://dl.dropbox.com/u/80622831/web2.gif

From doing a search online I couldn't find a solution. I thought it would be as simple as putting it on tab activate or something but I didn't know if that was available.

Thanks
Kaz

It is, you can't toggle the visibility of the webbrowser object, in the past I've used a workaround of tabstrip and moving the control off the form to the right.

I've,never been able to make the control work either in tabs or by changing visibility

Thanks for the replies guys..

I think the same.. my aim was to display gif images. Is there another way to display with gif images not using a web browser control?

Do you need them to be animated? If not the Picture control works fine for me

I want them to be animated and transparent or the same back colour as userform like in example attached above.

When the form is initialized it loads of web control... Is there code to unload the control? And then in a piece of code.. I could unload the control and load it again as if it is being initialised again.

That way I'll just add it to some of my buttons on the form.

This loads it.. but if I use this code again I get an error and im assuming cause it's already loaded. I want to maybe unload it and load it again if thats possible

Formula:

Please Login or Register  to view this content.

Kind Regards

---------- Post added at 08:14 AM ---------- Previous post was at 06:22 AM ----------

I managed to fix this to get it to do what I wanted.

Instead of having the gif images on the form. I positioned them exactly where they needed to be behind the form and then grouped them with the form so they stayed in the correct place.

I then used this code to bring the position of the images back and forward to the correct place on the right tab.

Formula:

Please Login or Register  to view this content.

Can you upload your work? I need to see how you did. I have a multipage with several tabs. In the first tab that is seen when I launch the form, I have a working gif. But when I move to the next tab and back to the first tab, the gif doesn't work anymore.