I have a drop down list in a cell. If the user selects "Euro" from the list,
how do I get cell B7 populated with the value 80 automatically. If they
select "STD" then cell B7 would need to be 100.

I have the values stored in the worksheet.

Is it possible to fill this in automatically depending on the user
selection, if so can some one please tell me how.

Thaks

andy