• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Employee Photo that changes depending of List Validation

omontero

New Member
Hi,


Is there any way to have photo in excel that changes depending on a selected employee code in a Data validation list in the same worksheet?


Im trying to do a employee profile dashboard with sales information like the one on the next link:

http://intranetblog.blogware.com/IBM%20fringe%20profile%20med.jpg


Still I haven't been able to change the picture in Excel depending on the user selection. I have the photos in a folder on a hard disk and they are named with the employee code.


Thanks for any help...
 

JP

New Member
Excel version?


I couldn't find any event in Excel 2003 that fires when you select an entry from a data validation dropdown list.
 

Hui

Excel Ninja
Staff member
You can do this without code using the Camera Tool

- Setup some columns with Name, Id and Picture

- The Picture Cells should all be the same size / height

- Paste the pictures into cells probably next to the Employees ID,

- Resize the Pics to fit within the cells, You Can use the Alt while dragging to snap to cell edges

- Name the Picture cells according to the ID, use Create Names, Left if the photos are next to the Id's

- Setup an area where you will setup a validation and use a List, select the employee's names column

- Setup a cell somewhere "EmployeeNo"which will use the Match Function to lookup the Employees name from the validated cell and return it's position from the employee list

- Setup a Named Range as Employee_Pic and make it equal to = Choose(EmployeeNo, List the employees in order)

- Now setup a Camera Tool where ever you want it

- Select the Camera tool and in the Formnula Bar type =Employee_Pic

You should now have a Pic of the employee list in the validation box.
 

keymaster

New Member
You can try the technique described here: http://chandoo.org/wp/2008/11/05/select-show-one-chart-from-many/


The technique is using camera tool and indirect formula to link a named range to an image. The article shows how to do this for a chart, but you can use a picture in the place of chart and it still works
 

omontero

New Member
Thanks Hui and Chandoo. Had read about the camera method in the "Select show one chart from-many" and was hoping for an alternative (I have 170 employees).


Guess Ill start pasting all photos :D


Thanks and if anyone have more suggestions keep them coming (don't mind if is a VB solution).


P.D. I'm using Excel 2007 but have installed Excel 2003 in my machine.

P.D.D. Yes I know I could use Access for this but I just don't have the time or knowledge to the all else I need to do.
 
Top