Hi All,

I was wondering if i could set the value of a cell simply by creating hyperlinks and clicking on them.
For example I want to be able to change to value of A1 simply by clicking on any one of the following countries. So if I click on Belgium, the A1 will change to Belgium, if i click on Germany, A1 will change to Germany.

Belgium
Germany
Finnland
France
Ireland
Italy
Luxemburg
Netherland
Austria
Portugal
Spain

I'm working on it my self and still looking for a way to overcome this.

Is this even possible?

I'm working to create a currency conversion in excel to improve my knowledge of the program.
I will share it with the forum once its complete.

Thanks

Resul