Multiple Picture display
 

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

Multiple Picture display
 

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

On Fri, 16 May 2008 06:46:01 -0700, Martin
wrote:

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

Multiple Picture display
 

Thank you Gord ! That work perfectly!!!

"Gord Dibben" wrote:

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

On Fri, 16 May 2008 06:46:01 -0700, Martin
wrote:

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

Multiple Picture display
 

Good to hear.

Thanks for posting back.


Gord

On Tue, 20 May 2008 05:16:02 -0700, Martin
wrote:

Thank you Gord ! That work perfectly!!!

"Gord Dibben" wrote:

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

On Fri, 16 May 2008 06:46:01 -0700, Martin
wrote:

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