'VBA : Number format = String Variable + "#,##0"

Very basic question - somehow can't solve this :-(

Can you please help me to set the number format on a cell to be a combination of a string variable and this number format : "#,##0"?

The objective is to have results appear as EUR #,##0 (if string variable = EUR) or GBP #,##0 (if string variable = GBP) etc.

So far, this is how I was trying to code it:

Dim Currency As String Set Currency = "EUR" Cells(1,1).NumberFormat = Currency & " #,##0"

Thank you in advance for your help!

Kind regards, Claudia

vba

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source