View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tgorath tgorath is offline
external usenet poster
 
Posts: 1
Default Currency Format via VBA

Hi,

I have to solve a problem with EXCEL 2000 and/or Excel 2002. The
current Currency format is $. All money related cells are formated
using the "currency format $". What I have to do is "relatively"
simple. The user will enter a new currency symbol using a dialog once
the spreadsheet is opened. This symbol either € or £ or ¥ has to be
the new format for ALL money related cells. How can that be done?

Thanks in advance,
Thiemo Gorath