I have two groups of images with links and I want to swap them base on condition

Question

I have two groups of image with their respectives links to link in the worksheet to sections, glossary or other sheet.

I want to superpose the group base on a condition.

If the condition says E for English, I want dynamically the image group for English GroupeE to be brought in front, and if the condition is change to F for French, I want the GroupeF to be brought in front, and of course the GroupeE will return back and so on.

Though I am not sure if it is the good way to do it.

1. Can I put the two images one overlapping the other one, and I can bring forward or backward dynamically.
2. Can I assign an image group assign or save in the worksheet (not external) to a cell ?
3. OR something I didn't think of yet.

Answer 1

Hi @Joël Delisle

Can I assign an image group assign or save in the worksheet (not external) to a cell?

You can't stack images via Insert > Pictures > Place in Cell. Via using Insert> Pictures > Place over cells, images can be stacked, but they are neither contained in nor linked to cells, you can't use formulas to swap them.

Can I put the two images one overlapping the other one, and I can bring forward or backward dynamically.

VBA code maybe helpful, I will add the "Office Developmemt" tag, see if there are any experts in VBA who can provide suggestions.

Thanks for your understanding.