Photos in cells?

[Ray]

I recently saw a pop music quiz using Excel. The photos of bands were in
the cells and the blank answer cell was beneath.
How can I put photos in a cell?
Thanks

 

[Tyro]

You can put pictures into Excel in the drawing layer above the worksheet and
then size the picture to make it look like it is in a cell. Insert/Picture
will do it.

Tyro

 

[Ron Coderre]

Here are a few options:

If you want to read the pictures from a folder:
http://www.contextures.com/excelfiles.html#CH0003

or....if you want to store the pictures in the Excel workbook:
http://www.mcgimpsey.com/excel/lookuppics.html

or…for an alternative non-VBA solution, in case you don't want to use
programming:

Assumption: Pictures are stored on Sheet2 to be dynamically shown on Sheet1.

Select Sheet2 and turn off Grid Lines
(Tools>Options>View tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. Insert>Picture from file. (select picture and put it in the sheet).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by the
dropdown list text:
Example for a picture of an Elephant:
Insert>Name>Define
Name: picElephant

2)Build your data validation list on a cell in Sheet1 and pick one of the
items.

3)Create a dynamic range name that refers to that cell:
Insert>Name>Define
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
....or whatever cell you chose.

4)Copy/Paste one of the pictures from Sheet2 to the display cell on Sheet1.

5)With the picture selected, type this in the formula bar, then press
[Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the dropdown
list.

Each time you select a different item in the list, the associated picture
will appear in the picture box and resize appropriately.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[Arvi Laanemets]

Hi Ron

I was curious enough to test this non-VBA solution right away. For me
(Excel2000) it works, but only when:
1. I select an item from dropdown;
2. , activate the picture on Sheet1;
3. , and activate the formula bar (select end of formula with mouse) and
press Enter.

Otherwise the picture remains unchanged!


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )

Here are a few options:

If you want to read the pictures from a folder:
http://www.contextures.com/excelfiles.html#CH0003

or....if you want to store the pictures in the Excel workbook:
http://www.mcgimpsey.com/excel/lookuppics.html

or…for an alternative non-VBA solution, in case you don't want to use
programming:

Assumption: Pictures are stored on Sheet2 to be dynamically shown on
Sheet1.

Select Sheet2 and turn off Grid Lines
(Tools>Options>View tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. Insert>Picture from file. (select picture and put it in the sheet).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by the
dropdown list text:
Example for a picture of an Elephant:
Insert>Name>Define
Name: picElephant

2)Build your data validation list on a cell in Sheet1 and pick one of the
items.

3)Create a dynamic range name that refers to that cell:
Insert>Name>Define
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
...or whatever cell you chose.

4)Copy/Paste one of the pictures from Sheet2 to the display cell on
Sheet1.

5)With the picture selected, type this in the formula bar, then press
[Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the dropdown
list.

Each time you select a different item in the list, the associated picture
will appear in the picture box and resize appropriately.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

I recently saw a pop music quiz using Excel. The photos of bands were in
the cells and the blank answer cell was beneath.
How can I put photos in a cell?
Thanks

 

[Ron Coderre]

Hmmm....that method has worked since at least Excel 5.

Can you save your workbook at one of the free file sharing sites and post
the link here so we can see what issue you're encountering?

Some free filehosts that could be used:
http://www.flypicture.com/
http://cjoint.com/index.php
http://www.savefile.com/index.php

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Hi Ron

I was curious enough to test this non-VBA solution right away. For me
(Excel2000) it works, but only when:
1. I select an item from dropdown;
2. , activate the picture on Sheet1;
3. , and activate the formula bar (select end of formula with mouse) and
press Enter.

Otherwise the picture remains unchanged!


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )

Here are a few options:

If you want to read the pictures from a folder:
http://www.contextures.com/excelfiles.html#CH0003

or....if you want to store the pictures in the Excel workbook:
http://www.mcgimpsey.com/excel/lookuppics.html

or…for an alternative non-VBA solution, in case you don't want to use
programming:

Assumption: Pictures are stored on Sheet2 to be dynamically shown on
Sheet1.

Select Sheet2 and turn off Grid Lines
(Tools>Options>View tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. Insert>Picture from file. (select picture and put it in the sheet).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by the
dropdown list text:
Example for a picture of an Elephant:
Insert>Name>Define
Name: picElephant

2)Build your data validation list on a cell in Sheet1 and pick one of the
items.

3)Create a dynamic range name that refers to that cell:
Insert>Name>Define
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
...or whatever cell you chose.

4)Copy/Paste one of the pictures from Sheet2 to the display cell on
Sheet1.

5)With the picture selected, type this in the formula bar, then press
[Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the dropdown
list.

Each time you select a different item in the list, the associated picture
will appear in the picture box and resize appropriately.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

I recently saw a pop music quiz using Excel. The photos of bands were in
the cells and the blank answer cell was beneath.
How can I put photos in a cell?
Thanks

 

[Arvi Laanemets]

Hi

I did open it anew today, and it did work now. It looks like the file must
be saved to get it working properly.



--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )

Hmmm....that method has worked since at least Excel 5.

Can you save your workbook at one of the free file sharing sites and post
the link here so we can see what issue you're encountering?

Some free filehosts that could be used:
http://www.flypicture.com/
http://cjoint.com/index.php
http://www.savefile.com/index.php

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Hi Ron

I was curious enough to test this non-VBA solution right away. For me
(Excel2000) it works, but only when:
1. I select an item from dropdown;
2. , activate the picture on Sheet1;
3. , and activate the formula bar (select end of formula with mouse) and
press Enter.

Otherwise the picture remains unchanged!


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )

Here are a few options:

If you want to read the pictures from a folder:
http://www.contextures.com/excelfiles.html#CH0003

or....if you want to store the pictures in the Excel workbook:
http://www.mcgimpsey.com/excel/lookuppics.html

or…for an alternative non-VBA solution, in case you don't want to use
programming:

Assumption: Pictures are stored on Sheet2 to be dynamically shown on
Sheet1.

Select Sheet2 and turn off Grid Lines
(Tools>Options>View tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. Insert>Picture from file. (select picture and put it in the sheet).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by the
dropdown list text:
Example for a picture of an Elephant:
Insert>Name>Define
Name: picElephant

2)Build your data validation list on a cell in Sheet1 and pick one of
the items.

3)Create a dynamic range name that refers to that cell:
Insert>Name>Define
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
...or whatever cell you chose.

4)Copy/Paste one of the pictures from Sheet2 to the display cell on
Sheet1.

5)With the picture selected, type this in the formula bar, then press
[Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the dropdown
list.

Each time you select a different item in the list, the associated
picture will appear in the picture box and resize appropriately.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


I recently saw a pop music quiz using Excel. The photos of bands were
in the cells and the blank answer cell was beneath.
How can I put photos in a cell?
Thanks

 

[vcff]

Hi

As I am also interested in this topic as I on-off also need to show pics, I
tried but not quite understand step No 2 & 3. Can help?

tnks

Hi

I did open it anew today, and it did work now. It looks like the file must
be saved to get it working properly.



--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )

Hmmm....that method has worked since at least Excel 5.

Can you save your workbook at one of the free file sharing sites and post
the link here so we can see what issue you're encountering?

Some free filehosts that could be used:
http://www.flypicture.com/
http://cjoint.com/index.php
http://www.savefile.com/index.php

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Hi Ron

I was curious enough to test this non-VBA solution right away. For me
(Excel2000) it works, but only when:
1. I select an item from dropdown;
2. , activate the picture on Sheet1;
3. , and activate the formula bar (select end of formula with mouse) and
press Enter.

Otherwise the picture remains unchanged!


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


Here are a few options:

If you want to read the pictures from a folder:
http://www.contextures.com/excelfiles.html#CH0003

or....if you want to store the pictures in the Excel workbook:
http://www.mcgimpsey.com/excel/lookuppics.html

or…for an alternative non-VBA solution, in case you don't want to use
programming:

Assumption: Pictures are stored on Sheet2 to be dynamically shown on
Sheet1.

Select Sheet2 and turn off Grid Lines
(Tools>Options>View tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. Insert>Picture from file. (select picture and put it in the sheet).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by the
dropdown list text:
Example for a picture of an Elephant:
Insert>Name>Define
Name: picElephant

2)Build your data validation list on a cell in Sheet1 and pick one of
the items.

3)Create a dynamic range name that refers to that cell:
Insert>Name>Define
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
...or whatever cell you chose.

4)Copy/Paste one of the pictures from Sheet2 to the display cell on
Sheet1.

5)With the picture selected, type this in the formula bar, then press
[Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the dropdown
list.

Each time you select a different item in the list, the associated
picture will appear in the picture box and resize appropriately.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


I recently saw a pop music quiz using Excel. The photos of bands were
in the cells and the blank answer cell was beneath.
How can I put photos in a cell?
Thanks

 

[Ron Coderre]

In Step_2, a Data Validation is created to ensure
that only specific values are allowed in the cell.

In Step_3, a Dynamic Range Name is created, which
automatically adjusts to reflect what is referenced
in the Data Validation cell.

For more information about Data Validation and Dynamic Range names, see
those topics at Debra Dalgleish's website:
http://www.contextures.com/xlDataVal01.html
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Hi

As I am also interested in this topic as I on-off also need to show pics,
I
tried but not quite understand step No 2 & 3. Can help?

tnks

Hi

I did open it anew today, and it did work now. It looks like the file
must
be saved to get it working properly.



--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )

Hmmm....that method has worked since at least Excel 5.

Can you save your workbook at one of the free file sharing sites and
post
the link here so we can see what issue you're encountering?

Some free filehosts that could be used:
http://www.flypicture.com/
http://cjoint.com/index.php
http://www.savefile.com/index.php

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Hi Ron

I was curious enough to test this non-VBA solution right away. For me
(Excel2000) it works, but only when:
1. I select an item from dropdown;
2. , activate the picture on Sheet1;
3. , and activate the formula bar (select end of formula with mouse)
and
press Enter.

Otherwise the picture remains unchanged!


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


Here are a few options:

If you want to read the pictures from a folder:
http://www.contextures.com/excelfiles.html#CH0003

or....if you want to store the pictures in the Excel workbook:
http://www.mcgimpsey.com/excel/lookuppics.html

or.for an alternative non-VBA solution, in case you don't want to use
programming:

Assumption: Pictures are stored on Sheet2 to be dynamically shown on
Sheet1.

Select Sheet2 and turn off Grid Lines
(Tools>Options>View tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. Insert>Picture from file. (select picture and put it in the
sheet).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by the
dropdown list text:
Example for a picture of an Elephant:
Insert>Name>Define
Name: picElephant

2)Build your data validation list on a cell in Sheet1 and pick one of
the items.

3)Create a dynamic range name that refers to that cell:
Insert>Name>Define
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
...or whatever cell you chose.

4)Copy/Paste one of the pictures from Sheet2 to the display cell on
Sheet1.

5)With the picture selected, type this in the formula bar, then press
[Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the
dropdown
list.

Each time you select a different item in the list, the associated
picture will appear in the picture box and resize appropriately.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


I recently saw a pop music quiz using Excel. The photos of bands
were
in the cells and the blank answer cell was beneath.
How can I put photos in a cell?
Thanks

 

[vcff]

tnks for the reply

Have being trying to figure out how the following works for the past hour
but still unable to.

What i dun understand is how do I build the data validation list on a cell
in Sheet1 and pick one of the items (meaning).

In cell G8:G10, I type picMe, picYou and picThem N name the three cell as
Name: Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)

cell A8 I create a data validation list
Copy picMe to cell A1
However, under A*, when I select picYou, the pic in A1 remains as picMe

What did I miss out or have I done wrongly?

In Step_2, a Data Validation is created to ensure
that only specific values are allowed in the cell.

In Step_3, a Dynamic Range Name is created, which
automatically adjusts to reflect what is referenced
in the Data Validation cell.

For more information about Data Validation and Dynamic Range names, see
those topics at Debra Dalgleish's website:
http://www.contextures.com/xlDataVal01.html
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Hi

As I am also interested in this topic as I on-off also need to show pics,
I
tried but not quite understand step No 2 & 3. Can help?

tnks

Hi

I did open it anew today, and it did work now. It looks like the file
must
be saved to get it working properly.



--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )



Hmmm....that method has worked since at least Excel 5.

Can you save your workbook at one of the free file sharing sites and
post
the link here so we can see what issue you're encountering?

Some free filehosts that could be used:
http://www.flypicture.com/
http://cjoint.com/index.php
http://www.savefile.com/index.php

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Hi Ron

I was curious enough to test this non-VBA solution right away. For me
(Excel2000) it works, but only when:
1. I select an item from dropdown;
2. , activate the picture on Sheet1;
3. , and activate the formula bar (select end of formula with mouse)
and
press Enter.

Otherwise the picture remains unchanged!


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


Here are a few options:

If you want to read the pictures from a folder:
http://www.contextures.com/excelfiles.html#CH0003

or....if you want to store the pictures in the Excel workbook:
http://www.mcgimpsey.com/excel/lookuppics.html

or.for an alternative non-VBA solution, in case you don't want to use
programming:

Assumption: Pictures are stored on Sheet2 to be dynamically shown on
Sheet1.

Select Sheet2 and turn off Grid Lines
(Tools>Options>View tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. Insert>Picture from file. (select picture and put it in the
sheet).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by the
dropdown list text:
Example for a picture of an Elephant:
Insert>Name>Define
Name: picElephant

2)Build your data validation list on a cell in Sheet1 and pick one of
the items.

3)Create a dynamic range name that refers to that cell:
Insert>Name>Define
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
...or whatever cell you chose.

4)Copy/Paste one of the pictures from Sheet2 to the display cell on
Sheet1.

5)With the picture selected, type this in the formula bar, then press
[Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the
dropdown
list.

Each time you select a different item in the list, the associated
picture will appear in the picture box and resize appropriately.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


I recently saw a pop music quiz using Excel. The photos of bands
were
in the cells and the blank answer cell was beneath.
How can I put photos in a cell?
Thanks

 

[Ron Coderre]

I think I see what's going wrong...

First, you have already pasted the three pictures into one of the sheets.
And...Named the range under each picture to correspond to the pictures:
picMe
picYou
picThem

THEN
Cells G8:G10, contain the text to display:
Me
You
Them

Name those cells: MyList

A8 contains the DV based on MyList
Click that cell and select one of the items.

NEXT
Creat the Dynamic Range name:
Names in Workbook: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$8)

Notice that it refers to cell A8...which contains the DV list
and prepends "pic" to the value.

So...if you selected "Them"
the ShowMyPic range would refer to the range "picThem".

LAST....continuing with the steps I posted:
4)Copy/Paste one of the pictures from the sheet with the pictures
to the display cell on the sheet with the DV cell.

5)WITH THE PICTURE SELECTED,
type the below formula in the formula bar, then press [Enter]:
=ShowMyPic

The picture will be replaced by the picture
referred to by the dropdown list.

Each time you select a different item in the list, the associated picture
will appear in the picture box and resize appropriately.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

tnks for the reply

Have being trying to figure out how the following works for the past hour
but still unable to.

What i dun understand is how do I build the data validation list on a cell
in Sheet1 and pick one of the items (meaning).

In cell G8:G10, I type picMe, picYou and picThem N name the three cell as
Name: Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)

cell A8 I create a data validation list
Copy picMe to cell A1
However, under A*, when I select picYou, the pic in A1 remains as picMe

What did I miss out or have I done wrongly?

In Step_2, a Data Validation is created to ensure
that only specific values are allowed in the cell.

In Step_3, a Dynamic Range Name is created, which
automatically adjusts to reflect what is referenced
in the Data Validation cell.

For more information about Data Validation and Dynamic Range names, see
those topics at Debra Dalgleish's website:
http://www.contextures.com/xlDataVal01.html
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Hi

As I am also interested in this topic as I on-off also need to show
pics,
I
tried but not quite understand step No 2 & 3. Can help?

tnks

:

Hi

I did open it anew today, and it did work now. It looks like the file
must
be saved to get it working properly.



--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )



Hmmm....that method has worked since at least Excel 5.

Can you save your workbook at one of the free file sharing sites and
post
the link here so we can see what issue you're encountering?

Some free filehosts that could be used:
http://www.flypicture.com/
http://cjoint.com/index.php
http://www.savefile.com/index.php

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Hi Ron

I was curious enough to test this non-VBA solution right away. For
me
(Excel2000) it works, but only when:
1. I select an item from dropdown;
2. , activate the picture on Sheet1;
3. , and activate the formula bar (select end of formula with
mouse)
and
press Enter.

Otherwise the picture remains unchanged!


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


Here are a few options:

If you want to read the pictures from a folder:
http://www.contextures.com/excelfiles.html#CH0003

or....if you want to store the pictures in the Excel workbook:
http://www.mcgimpsey.com/excel/lookuppics.html

or.for an alternative non-VBA solution, in case you don't want to
use
programming:

Assumption: Pictures are stored on Sheet2 to be dynamically shown
on
Sheet1.

Select Sheet2 and turn off Grid Lines
(Tools>Options>View tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. Insert>Picture from file. (select picture and put it in the
sheet).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by
the
dropdown list text:
Example for a picture of an Elephant:
Insert>Name>Define
Name: picElephant

2)Build your data validation list on a cell in Sheet1 and pick one
of
the items.

3)Create a dynamic range name that refers to that cell:
Insert>Name>Define
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
...or whatever cell you chose.

4)Copy/Paste one of the pictures from Sheet2 to the display cell
on
Sheet1.

5)With the picture selected, type this in the formula bar, then
press
[Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the
dropdown
list.

Each time you select a different item in the list, the associated
picture will appear in the picture box and resize appropriately.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


I recently saw a pop music quiz using Excel. The photos of bands
were
in the cells and the blank answer cell was beneath.
How can I put photos in a cell?
Thanks

 

[vcff]

Tnks for your help, I am able to received the pic I selected now.

Have A Nice Day.

I think I see what's going wrong...

First, you have already pasted the three pictures into one of the sheets.
And...Named the range under each picture to correspond to the pictures:
picMe
picYou
picThem

THEN
Cells G8:G10, contain the text to display:
Me
You
Them

Name those cells: MyList

A8 contains the DV based on MyList
Click that cell and select one of the items.

NEXT
Creat the Dynamic Range name:
Names in Workbook: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$8)

Notice that it refers to cell A8...which contains the DV list
and prepends "pic" to the value.

So...if you selected "Them"
the ShowMyPic range would refer to the range "picThem".

LAST....continuing with the steps I posted:
4)Copy/Paste one of the pictures from the sheet with the pictures
to the display cell on the sheet with the DV cell.

5)WITH THE PICTURE SELECTED,
type the below formula in the formula bar, then press [Enter]:
=ShowMyPic

The picture will be replaced by the picture
referred to by the dropdown list.

Each time you select a different item in the list, the associated picture
will appear in the picture box and resize appropriately.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

tnks for the reply

Have being trying to figure out how the following works for the past hour
but still unable to.

What i dun understand is how do I build the data validation list on a cell
in Sheet1 and pick one of the items (meaning).

In cell G8:G10, I type picMe, picYou and picThem N name the three cell as
Name: Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)

cell A8 I create a data validation list
Copy picMe to cell A1
However, under A*, when I select picYou, the pic in A1 remains as picMe

What did I miss out or have I done wrongly?

In Step_2, a Data Validation is created to ensure
that only specific values are allowed in the cell.

In Step_3, a Dynamic Range Name is created, which
automatically adjusts to reflect what is referenced
in the Data Validation cell.

For more information about Data Validation and Dynamic Range names, see
those topics at Debra Dalgleish's website:
http://www.contextures.com/xlDataVal01.html
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)




Hi

As I am also interested in this topic as I on-off also need to show
pics,
I
tried but not quite understand step No 2 & 3. Can help?

tnks

:

Hi

I did open it anew today, and it did work now. It looks like the file
must
be saved to get it working properly.



--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )



Hmmm....that method has worked since at least Excel 5.

Can you save your workbook at one of the free file sharing sites and
post
the link here so we can see what issue you're encountering?

Some free filehosts that could be used:
http://www.flypicture.com/
http://cjoint.com/index.php
http://www.savefile.com/index.php

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Hi Ron

I was curious enough to test this non-VBA solution right away. For
me
(Excel2000) it works, but only when:
1. I select an item from dropdown;
2. , activate the picture on Sheet1;
3. , and activate the formula bar (select end of formula with
mouse)
and
press Enter.

Otherwise the picture remains unchanged!


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


Here are a few options:

If you want to read the pictures from a folder:
http://www.contextures.com/excelfiles.html#CH0003

or....if you want to store the pictures in the Excel workbook:
http://www.mcgimpsey.com/excel/lookuppics.html

or.for an alternative non-VBA solution, in case you don't want to
use
programming:

Assumption: Pictures are stored on Sheet2 to be dynamically shown
on
Sheet1.

Select Sheet2 and turn off Grid Lines
(Tools>Options>View tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. Insert>Picture from file. (select picture and put it in the
sheet).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by
the
dropdown list text:
Example for a picture of an Elephant:
Insert>Name>Define
Name: picElephant

2)Build your data validation list on a cell in Sheet1 and pick one
of
the items.

3)Create a dynamic range name that refers to that cell:
Insert>Name>Define
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
...or whatever cell you chose.

4)Copy/Paste one of the pictures from Sheet2 to the display cell
on
Sheet1.

5)With the picture selected, type this in the formula bar, then
press
[Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the
dropdown
list.

Each time you select a different item in the list, the associated
picture will appear in the picture box and resize appropriately.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


I recently saw a pop music quiz using Excel. The photos of bands
were
in the cells and the blank answer cell was beneath.
How can I put photos in a cell?
Thanks

 

[Ron Coderre]

You're welcome......I'm glad I could help.

--------------------------
Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Tnks for your help, I am able to received the pic I selected now.

Have A Nice Day.

I think I see what's going wrong...

First, you have already pasted the three pictures into one of the sheets.
And...Named the range under each picture to correspond to the pictures:
picMe
picYou
picThem

THEN
Cells G8:G10, contain the text to display:
Me
You
Them

Name those cells: MyList

A8 contains the DV based on MyList
Click that cell and select one of the items.

NEXT
Creat the Dynamic Range name:
Names in Workbook: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$8)

Notice that it refers to cell A8...which contains the DV list
and prepends "pic" to the value.

So...if you selected "Them"
the ShowMyPic range would refer to the range "picThem".

LAST....continuing with the steps I posted:
4)Copy/Paste one of the pictures from the sheet with the pictures
to the display cell on the sheet with the DV cell.

5)WITH THE PICTURE SELECTED,
type the below formula in the formula bar, then press [Enter]:
=ShowMyPic

The picture will be replaced by the picture
referred to by the dropdown list.

Each time you select a different item in the list, the associated picture
will appear in the picture box and resize appropriately.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

tnks for the reply

Have being trying to figure out how the following works for the past
hour
but still unable to.

What i dun understand is how do I build the data validation list on a
cell
in Sheet1 and pick one of the items (meaning).

In cell G8:G10, I type picMe, picYou and picThem N name the three cell
as
Name: Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)

cell A8 I create a data validation list
Copy picMe to cell A1
However, under A*, when I select picYou, the pic in A1 remains as picMe

What did I miss out or have I done wrongly?

:

In Step_2, a Data Validation is created to ensure
that only specific values are allowed in the cell.

In Step_3, a Dynamic Range Name is created, which
automatically adjusts to reflect what is referenced
in the Data Validation cell.

For more information about Data Validation and Dynamic Range names,
see
those topics at Debra Dalgleish's website:
http://www.contextures.com/xlDataVal01.html
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)




Hi

As I am also interested in this topic as I on-off also need to show
pics,
I
tried but not quite understand step No 2 & 3. Can help?

tnks

:

Hi

I did open it anew today, and it did work now. It looks like the
file
must
be saved to get it working properly.



--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )



Hmmm....that method has worked since at least Excel 5.

Can you save your workbook at one of the free file sharing sites
and
post
the link here so we can see what issue you're encountering?

Some free filehosts that could be used:
http://www.flypicture.com/
http://cjoint.com/index.php
http://www.savefile.com/index.php

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Hi Ron

I was curious enough to test this non-VBA solution right away.
For
me
(Excel2000) it works, but only when:
1. I select an item from dropdown;
2. , activate the picture on Sheet1;
3. , and activate the formula bar (select end of formula with
mouse)
and
press Enter.

Otherwise the picture remains unchanged!


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


message
Here are a few options:

If you want to read the pictures from a folder:
http://www.contextures.com/excelfiles.html#CH0003

or....if you want to store the pictures in the Excel workbook:
http://www.mcgimpsey.com/excel/lookuppics.html

or.for an alternative non-VBA solution, in case you don't want
to
use
programming:

Assumption: Pictures are stored on Sheet2 to be dynamically
shown
on
Sheet1.

Select Sheet2 and turn off Grid Lines
(Tools>Options>View tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. Insert>Picture from file. (select picture and put it in the
sheet).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed
by
the
dropdown list text:
Example for a picture of an Elephant:
Insert>Name>Define
Name: picElephant

2)Build your data validation list on a cell in Sheet1 and pick
one
of
the items.

3)Create a dynamic range name that refers to that cell:
Insert>Name>Define
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
...or whatever cell you chose.

4)Copy/Paste one of the pictures from Sheet2 to the display
cell
on
Sheet1.

5)With the picture selected, type this in the formula bar, then
press
[Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the
dropdown
list.

Each time you select a different item in the list, the
associated
picture will appear in the picture box and resize
appropriately.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


I recently saw a pop music quiz using Excel. The photos of
bands
were
in the cells and the blank answer cell was beneath.
How can I put photos in a cell?
Thanks