Hello All,
Could anyone help me with a step by step guide to position a picture on
a spreadsheet that is linked to an entry in a drop down box, so that
when an entry is selected, the picture linked to that selection is
displayed on the sheet.
The drop down box is in F3 and contains the entries .... Aircraft,
Ships and Trains.
I have a jpeg picture of an Aircraft, a Ship and a Train but each
picture is a different size. There is an area starting at X16 on my sheet
where I can store the pictures.
I wish to position the picture corresponding to my selection at A1 in an
area approximately 40mm*40mm.
Tried several times myself, but can't get it to work and I'm just
getting confused.
Would be most grateful for any assistance, please!
Regards.
Rick
Could anyone help me with a step by step guide to position a picture on
a spreadsheet that is linked to an entry in a drop down box, so that
when an entry is selected, the picture linked to that selection is
displayed on the sheet.
The drop down box is in F3 and contains the entries .... Aircraft,
Ships and Trains.
I have a jpeg picture of an Aircraft, a Ship and a Train but each
picture is a different size. There is an area starting at X16 on my sheet
where I can store the pictures.
I wish to position the picture corresponding to my selection at A1 in an
area approximately 40mm*40mm.
Tried several times myself, but can't get it to work and I'm just
getting confused.
Would be most grateful for any assistance, please!
Regards.
Rick