Userform + changing image on click
Posted by Pasi Vartiainen on October 17, 2000 11:55 PM
I am wondering, if it is possible to have userform, which has feature like this:
- When some check or optionbox is clicked, an image of component appears to empty region, or into same frame.
- Image is changed, when another check or optionbox is clicked
- Images are stored in excel workbook, in other words, there is only one file containing everything.
Is this possible? I am just thinkin this kind of solution, but if it is impossible, or extremely difficult, I must try something else.
I hope someone can help me.
Pasi Vartiainen
Posted by Ivan Moala on October 18, 2000 4:05 AM
It is possible BUT code is long because basically
copying an image from a Pict from excel sheet to
a userform cannot be done....what you need to do
is a workaround involving setting up your images
as a chart and then exporting them to a temp dir
so that you can load it in your Userform.....thats
the only way I know of doing this ?.....so far!
See if anyone else has other ideas....I've looked
at some old coding and it is possible....just
a bit of work.
Ivan
