Pilot5000
New Member
I found an even easier way.
I created two columns:
FX Name FX Symbol
Listed out all of the names and symbols in a worksheet, named the range fx_rates
then when the user selects the currency they want to convert to, the user chooses the currency in the pull down menu, to convert all numbers to the appropriate currency.
then in a cell ("E3") in the FX rates worksheet, i do a vlookup to match the appropriate symbol,
then call the sub to apply the format to all of the cells that i want converted.
Sub Currency_Calculate()
Currency_Symbol = Worksheets("FX rates").Range("E3")
Worksheets("Calculator").Range("F11:N49").NumberFormat = Currency_Symbol & " #,##0.00"
End Sub
fast and simple and not a lot of coding. in addition, if i ever do any updates, i won't have to refer to the VBA code, but rather my named ranges.
dear Luke M
i read your post and i liked it very much i am presently in middle of project that deal with the same problems , i tired to work with your explanation but something is not working i get the message "unable to set the number format property of the range class " when i tried to run the macro , therefore i will appreciate if you can create a sample of your post in worksheet and upload it so it will become more clear, thank you in advance and i hope i am not asking for too much ............
good news it work wonderful i love that idea , thank you for the good job and sorry for the disturbance
Last edited: