setting currency symbol in vba

[thomas donino]

Using number formatting you can set a currency symbol in a cell
like below for the euro. How is it done in vba?

€ 72.80

 

[Don Guillett]

The macro recorder is your friend

 

[Gary''s Student]

From the Recorder:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 9/11/2009 by James Ravenswood
'

'
Selection.NumberFormat = "[$€-2] #,##0.00"
End Sub