title: Currency converter applied to range via combobox
body: <p>Is there a way to apply vba code to convert the currency of a range of cells without changing the formula within the cell based upon the type of currency chosen in a drop-down box.</p>
  
  <p>So for instance:</p>
  
  <p>1.) drop-down box(Hong Kong, London, Berlin)</p>
  
  <p>2.) You choose (Hong Kong)</p>
  
  <p>3.) sheet1.range("A5:A7") and sheet1.range("G5:G7") and sheet10.range("B5:B6") all change to the currency of the chosen location (i.e. HKD)</p>
  
  <p>4.) You choose (Berlin) and all of the cells then adjust to Euros.</p>
  
  <p>Is this type of vba even possible? How should I go about trying to code it.</p>
  
  <p>Thank you.</p>