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?
--
Garyw

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


"Garyw" wrote:

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?
--
Garyw

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....
--
Garyw


"BigPig" wrote:

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


"Garyw" wrote:

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?
--
Garyw

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

On Mon, 30 Apr 2007 06:24:03 -0700, Garyw
wrote:

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....