Multiple Picture display

[Martin]

Hi I have a Excel sheet that I need to have a choice of 5 picture display in
different line (line I2 to Line I30). On each cell I2, I3, I4.....

I need to have a choice to select a % (0%, 25%, 50%, 75%, 100%). When I
select a %, I need to have a picture on the right cell (Column J) that appear
(It's a circle with 100% filled, 75% filled.....)

I'm able to do it for 1 cell but I'm unable to do this for a serie of cell.
Any Help will be very appreciated

Martin

 

[Gord Dibben]

Martin

Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for
adding pictures to selections.

Alows for more than one picture to be displayed based upon a value or item
chosen from a DV list

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0049 - ClipArt Selection

Edit the code to suit.


Gord Dibben MS Excel MVP

 

[Martin]

Thank you Gord ! That work perfectly!!!

Martin

Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for
adding pictures to selections.

Alows for more than one picture to be displayed based upon a value or item
chosen from a DV list

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0049 - ClipArt Selection

Edit the code to suit.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Good to hear.

Thanks for posting back.


Gord

Thank you Gord ! That work perfectly!!!