View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Enz Enz is offline
external usenet poster
 
Posts: 21
Default Currency List Dropdown for Worksheet

I have a worksheet where I would like to create a list that contains
all the currencies that Excel has available (similar as when you
select Format - Cells - Number - Currency, and then there is a
dropdown list for Symbol). Once the person selects the currency the
Worksheet numeric cells are then formatted with the currency
selected. I am aware of the NumberFormat, and I have recorded a macro
that obtains the currency selected. The part I am not sure how to do
is to get the list of the currencies that Excel has, that I can
display in my List for the user to choose from?

I think this probably has been done, but I have not been able to
locate a sample yet. Any ideas or recommendations?

thanks,
Enzo