Hiding and unhiding pictures

[Guest]

I wish to stack pictures, inserted from AutoCad as (.wmf) in one area of the
worksheet and have them hide and unhide if one of several check boxes is
checked. How do I accomplish this?

 

[Guest]

Garyw,

I would start by placing the pic in a label.

Then make visible=false

In your code, tie it to your check box(es) and " label(?).visible=true

Don't forget to make the other labels' visible equal to false.

HTH

BigPig

 

[Guest]

I know just enough about Visual Basic to make me dangerous.
Would you please write a complete sample code that I might
run it and try to understand how it works. Then next time I come
to a problem like this I'll know what to do.

Thanks....

 

[Gord Dibben]

Gary

Maybe you can employ event code and VLOOKUP with Data Validation list selection
to choose which picture to show?

See JE McGimpsey's site for more on lookuppics.

http://www.mcgimpsey.com/excel/lookuppics.html


Gord Dibben MS Excel MVP