SOLVED

How do I put multiple clickable cells on top of an image? and can I draw the shape of the cells?

%3CLINGO-SUB%20id%3D%22lingo-sub-2061523%22%20slang%3D%22en-US%22%3EHow%20do%20I%20put%20multiple%20clickable%20cells%20on%20top%20of%20an%20image%3F%20and%20can%20I%20draw%20the%20shape%20of%20the%20cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2061523%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20be%20able%20to%20make%20sections%20of%20an%20image%20clickable%20to%20change%20the%20cell%20colour.%3C%2FP%3E%3CP%3EI%20can%20see%20how%20to%20insert%20an%20image%20in%20a%20cell%2C%20but%20I%20need%20the%20image%20to%20be%20across%20multiple%20cells%3A%20each%20of%20which%20can%20be%20clicked%20to%20change%20the%20cell%20colour.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhat%20I'm%20trying%20to%20create%20is%20a%20nursing%20chart%20with%20a%20picture%20of%20the%20human%20body%2C%20where%20you%20can%20click%20a%20section%20of%20the%20body%2C%20say%20upper%20arm%20or%20shoulder%2C%20and%20that%20part%20is%20highlighted%2C%20to%20show%20where%20medication%20is%20to%20be%20applied.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20has%20to%20be%20as%20simple%20as%20point%20and%20click%20for%20the%20end%20user%20as%20they're%20not%20trained%20in%20Excel%20(nor%20am%20I%2C%20but%20I'm%20tech%20savvy)%3C%2FP%3E%3CP%3ECan%20you%20draw%20the%20shape%20of%20a%20cell%3F%20obviously%20I%20can%20resize%20them%2C%20but%20do%20they%20have%20to%20be%20rectilinear%3F%3C%2FP%3E%3CP%3ECan%20I%20draw%20a%20cell%20over%20a%20lower%20arm%20and%20another%20over%20the%20hand%3F%20etc%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20might%20not%20be%20the%20best%20program%20for%20this%2C%20but%20it%20has%20to%20be%20used%20as%20other%20sections%20of%20the%20form%20need%20to%20do%20sequential%20dates%20etc%20(that%20bit's%20easy)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20saw%20a%20VBA%20script%20that%20will%20change%20a%20cell%20colour%20by%20double%20clicking%20it%2C%20revert%20by%20right%20clicking%20which%20is%20Ideal.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20far%20the%20only%20solution%20I%20can%20think%20of%20is%20laborious%3A%26nbsp%3B%20to%20deconstruct%20the%20image%20into%20constituent%20parts%2C%20then%20put%20them%20individually%20into%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20any%20assistance%3C%2FP%3E%3CP%3ENic.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2061523%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2068508%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20put%20multiple%20clickable%20cells%20on%20top%20of%20an%20image%3F%20and%20can%20I%20draw%20the%20shape%20of%20the%20cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2068508%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F929301%22%20target%3D%22_blank%22%3E%40nic-nicol%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20had%20some%20success%20on%20this%20with%20help%20from%20several%20folk%20here%2C%20the%20progress%20can%20be%20seen%20on%20this%20thread...%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Ftrying-to-toggle-colour-of-shapes-on-mouse-click%2Fm-p%2F2068348%2Fhighlight%2Ffalse%23M86206%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Ftrying-to-toggle-colour-of-shapes-on-mouse-click%2Fm-p%2F2068348%2Fhighlight%2Ffalse%23M86206%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I want to be able to make sections of an image clickable to change the cell colour.

I can see how to insert an image in a cell, but I need the image to be across multiple cells: each of which can be clicked to change the cell colour.

 

what I'm trying to create is a nursing chart with a picture of the human body, where you can click a section of the body, say upper arm or shoulder, and that part is highlighted, to show where medication is to be applied.

 

It has to be as simple as point and click for the end user as they're not trained in Excel (nor am I, but I'm tech savvy)

Can you draw the shape of a cell? obviously I can resize them, but do they have to be rectilinear?

Can I draw a cell over a lower arm and another over the hand? etc

 

Excel might not be the best program for this, but it has to be used as other sections of the form need to do sequential dates etc (that bit's easy)

 

I saw a VBA script that will change a cell colour by double clicking it, revert by right clicking which is Ideal.

 

So far the only solution I can think of is laborious:  to deconstruct the image into constituent parts, then put them individually into cells.

 

Thanks in advance for any assistance

Nic.

 

 

 

1 Reply
best response confirmed by nic-nicol (Occasional Contributor)
Solution

@nic-nicol 

 

Have had some success on this with help from several folk here, the progress can be seen on this thread...

https://techcommunity.microsoft.com/t5/excel/trying-to-toggle-colour-of-shapes-on-mouse-click/m-p/20...