Hello,
I have an excel where I will select a Currency dropdown (USD,EUR,GBP,SGD). On selecting any one of the currencies, I need to change the currency symbol in multiple cells where the amount is entered.
My Drop down column & Amount column looks like this;
CELL LABEL CURRENCY
B5 Currency SGD
B23 Item amount (net!) 45.00
B29 Item amount (net!) 10.00
Thanks,
Vivek
vivek.vivek
0
Light Poster
Recommended Answers
Jump to PostUse the ActiveX ComboBox. It has a change event that you can handle. Also the changes that it makes to the linked cell also triggers the WorkSheet_Change event. The Forms drop down does not do this.
Jump to PostAre you just wanting to display the currency symbol depending on the currency chosen from your dropdown in Cell 'B5'? Could you show the layout, as it would be in Excel, the way you want it displayed?
Jump to PostIf you only want the symbols to change you could alway just place the below formula in an adjacent cell and format to hide the divide between them.
=IF($B$5="USD","$",IF($B$5="EUR","€",IF($B$5="GBP","£",IF($B$5="SGD","S$",""))))
Using this will change the symbol to what ever is selected in your dropdown in cell 'B5'.
Jump to PostI tend to use named ranges a lot when doing spreadsheet programming so I decided to attach a sample file for you to look at. I named the dropdown cell "SelectedCurrency" and the search text is "CurrencyTag" on the Data tab.
The code is:
Private Sub Worksheet_Change(ByVal …
Jump to PostAre you wanting the symbol in the same cell as the dollar values or in a cell next to it?
Could we see where in the code, and at what point, or when you would expect to see the symbol associated to the cell? Maybe a visual layout of what …
All 17 Replies
TnTinMN
418
Practically a Master Poster
demon916
25
Newbie Poster
demon916
25
Newbie Poster
vivek.vivek
0
Light Poster
TnTinMN
418
Practically a Master Poster
demon916
25
Newbie Poster
TnTinMN
418
Practically a Master Poster
vivek.vivek
0
Light Poster
vivek.vivek
0
Light Poster
TnTinMN
418
Practically a Master Poster
demon916
25
Newbie Poster
vivek.vivek
0
Light Poster
vivek.vivek
0
Light Poster
demon916
25
Newbie Poster
vivek.vivek
0
Light Poster
demon916
25
Newbie Poster
vivek.vivek
0
Light Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.