货币转换器通过组合框应用于范围-Currencyconverterappliedtorangeviacombobox

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.

有没有办法应用vba代码转换一系列单元格的货币,而不根据下拉框中选择的货币类型更改单元格内的公式。

So for instance:

例如:

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

1.)下拉框(香港,伦敦,柏林)

2.) You choose (Hong Kong)

2.)你选择(香港)

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)

3.)sheet1.range(“A5:A7”)和sheet1.range(“G5:G7”)和sheet10.range(“B5:B6”)都变为所选位置的货币(即HKD)

4.) You choose (Berlin) and all of the cells then adjust to Euros.

4.)您选择(柏林),然后所有单元格调整为欧元。

Is this type of vba even possible? How should I go about trying to code it.

这种类型的vba甚至可能吗?我应该怎么去尝试编码呢。

Thank you.

1 个解决方案

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = Range("A1").Address Then
        'your code
    End If 
End Sub