LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show worksheet ComboBox DropDown list even when your not in it [email protected] Excel Programming 1 February 9th 07 06:28 PM
dropdown list to a page in worksheet Jared New Users to Excel 13 August 31st 06 06:44 PM
Worksheet List, Dropdown List Excel 2000! [email protected] Excel Programming 0 July 8th 06 05:06 AM
how can I remove a dropdown list from my worksheet Boomer Excel Discussion (Misc queries) 3 April 4th 06 04:02 PM
Pull list / dropdown data from another worksheet? Annabelle Excel Discussion (Misc queries) 2 February 16th 06 03:32 PM


All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"