How to get cell format accounting currency based on value in combobox

A

AA Arens

Hi I have tried to find out from earlier messages but failed.

I am looking for the following

I need to fill in payments from our customers. In the left column I
choose via combo box the currency of the invoice. How to get the cell
account formatting from all cells right of it in a certain currency
that I choose from the combo? (VB code)

So:
A1 B1 C1 etc.
Combo: Cell format:
US Dollar USD USD
Euro EUR EUR


Thank you


Bart
Excel 2003
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to format cell depend on combo choice from another cell 3
how to totalize only column value from certain accounting -> Currencyformat 10
Code to have cells in the row formatted "Italics" when combo boxvalue is set 5
filter on currency number format 3
List of currency codes - are they are all the same? 2
Macro to Run Functions and VBA code??? 0
Combobox value populate cell selection 3
How to "Scrape" currency conversions off web... Maybe using Google 1

Top