excel vba - Currency converter applied to range via combobox -

Whether to apply the VBA code to convert range of cells without changing the formulas without cell formulas One way

1.) Drop-down box (Hong Kong, London, Berlin)

For example:

1. P> 2) You choose (Hong Kong)

3.) Sheet 1.Range ("A5: A7") and Sheet 1.Range ("G5: G7") and Sheet 10 .Range ("B5: B6") All changes in the currency of the selected place (i.e. HACC)

4) You choose (Berlin) and all cells then adjust for the Euro.

Is it also possible to type Vba?

1 - Use data validation to create a drop down list in your code

< P> 2- Use the following event handler to check whether the value of a cell has changed

  if the goal is to be taken as a range) . Address = range ("A1"). If your address is the cell with the A1 drop down list 
 
 3- Formatting the code to apply the code to add the macro Use recorder.