[SOLVED] Signature in drop down

[Dowjd]

Anyone know how I can have a cell display a persons name, signature and title in a drop down list?

I have the name and title completed and assumed I could just insert a picture of the signature in the cell source and it would show in the drop down. It does not.

Any suggestions?

thanks

[JBeaucaire]

I believe the only way will be with a macro, that means VBA has to be enabled all the time for you and for whomever else might use the sheet.

[Dowjd]

Thanks for the reply.

Can you give me the formula or procedure?

[Dowjd]

Let me clarify what I need.

Example:

In cell A21 I need a drop down list that contains:

a persons name(text), their signature(pic) and their job title(text).

Currently I have the drop down list with the following formula (=$A$42:$A$45). I have the signature(pics) pasted along with the text in the data source cells (A42:A45), but when I use the drop down the signature(pics) will not display in cell A21.

Anyone know what I am doing wrong? Is what I need possible?

Thanks

[WHER]

Not 100% what you wanted, but close enough i hope. The code was "googled", not my work.

[martindwilson]

it can be done without code as demonstrated by cullen8 here
http://www.excelforum.com/excel-gene...ell-value.html
i have attached a slightly different version using a drop down to retrieve the images.
to clarify the image on sheet one is done by insert /object i chose bitmap
then edited as stated by cullen8 in the formula bar
=EMBED("Paint.Picture","")
to =showmypic