Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show worksheet ComboBox DropDown list even when your not in it | Excel Programming | |||
dropdown list to a page in worksheet | New Users to Excel | |||
Worksheet List, Dropdown List Excel 2000! | Excel Programming | |||
how can I remove a dropdown list from my worksheet | Excel Discussion (Misc queries) | |||
Pull list / dropdown data from another worksheet? | Excel Discussion (Misc queries) |