Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formating
I have a number of textboxs, which display formated
numbers and currency symbols. I would like to expand my worksheet to include other currencies, like ?, ¢, £, etc. I know that I can set up if then statments to account for users selection of currency, however, That involves an aweful lot of duplicate code considering the number of textboxes, and the currencies i would like to support. the formatted text line looks like this TBPrt.Text = Format(Worksheets("pricing").Range ("ad4"), "$##,##0.00") Is there an easy way for me to have that currency symbol be variable based on user selection of currency on the title page. Any assistance on an easier way than just doing if then statements would be greatly appreciated. Thanks Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formating
David,
If I understand correctly, could you not setup a module level variable for the currency format. Something like ccyFormat = ccyId & "#,###,##0.00" where ccyId is the selected currecncy symol, £, $ or whatever, and then use like TBPrt.Text = Format(Worksheets("pricing").Range("ad4"), ccyFormat) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "David" wrote in message ... I have a number of textboxs, which display formated numbers and currency symbols. I would like to expand my worksheet to include other currencies, like ?, ¢, £, etc. I know that I can set up if then statments to account for users selection of currency, however, That involves an aweful lot of duplicate code considering the number of textboxes, and the currencies i would like to support. the formatted text line looks like this TBPrt.Text = Format(Worksheets("pricing").Range ("ad4"), "$##,##0.00") Is there an easy way for me to have that currency symbol be variable based on user selection of currency on the title page. Any assistance on an easier way than just doing if then statements would be greatly appreciated. Thanks Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Help Please with Conditional FOrmating | Excel Worksheet Functions | |||
conditional formating | Excel Discussion (Misc queries) | |||
Conditional formating | Excel Discussion (Misc queries) |