First off, I would dump the big table for a simple list of exchange rates
in terms of one currency.
Since I'm in the US, I would tend to choose USD. The table would need a USD
to USD = 1
entry to work right. The exchange rate between any 2 currencies would be
the ratio of the to and from
USD entries. This way, a simple vlookup function could get the 2 exchange
rates based on the value
returned by combo boxes. The combo box from the control box can be assigned
inputs and outputs through the properties vs. the form controls that require
vba.

Basically you would need:
A list with 2 columns. Currency code in the first and the USD exchange rate
in the second
2 combo boxes that both referring to column 1 for the list of options in the
combo box and 2 different cells for the selection.
Finally, a cell with something like: = vlookup(combo out 1, list of rates,
2)/vlookup(combo out 2, list of rates, 2)
You may need to invert the formula depending on if the table is USD to X or
X to USD.

If you really want a square table, I would use a match function on the
column headings
to get the offset to use in a vlookup on the rows.

"Dave" wrote in message
...
OK, Ill do my best to describe what I am trying to achieve, all help
appreciated, so lets set the scene!:

I have put together a table for viewing various exchange rates (roughly 30
rows by 30 columns to be precise) with a view to being able to automatically
extract the correct rate from it in conjuction with a combobox as the means
for doing this.

Worksheet 1 contains a 'select the currency from' combobox list and a
'select the currency to' combobox list

Worksheet 2 has the exchange rate table in it.

What I want to achieve is when an exchange rate is selected from the 2
combo boxes on worksheet 1 it triggers a formula to go to worksheet 2, read
and publish the appropriate rate but I have run out of ideas to do this,
help please!!

The logic I have been trying to apply is to name each of the rows and
colums of figures in the table (Lets say for example the row of USD Dollar
rates, USD and the column of UK Pound Rates, UKP) there will then be only
one instance where those ranges contain the same cell, ie where they cross
and that would give me the rate i need :)

I would use the comboboxes to give me the required currencies in the
linked cells and then use the answers in the linked cells in someway to read
the correct rate from the currency table.

Help please.

Thanks