Nick,
Thankl you for your answer to my query. I had already done what you
suggested (I think). The lists I mentioned are in drop down lists as provided
in EXCEL. The abbreviations are in the adjacent columns to the lists. What I
don't know how to do is for example I pick Gallons in the "From List" and
Litres from the "To List" then when I use the CONVERT Function I need EXCEL
to automatically use the adjacent cells information which contain "gal" and
"L" respectively. If I manually input the adjacent cells' abbreviation in the
convert function it works allright! So it's the automated bit is what I am
having difficulty with.
Regards
Tony Borg
--
TonyB


"NickHK" wrote:

Tony,
The cheat way would be to have the expected abbreviations (see the Help) for
these units in the adjacent column and call the CONVERT worksheet functions
with quantities.

NickHK

"Tony Borg" wrote in message
...
I have set up two lists in EXCEL with different units eg, Gallons, Litres,
Degrees Celsius, Degree Fahrenheit, Degrees Kelvin etc. etc. The two lists
are identical. I want users to be able to select a "From Unit" from one
list
and a "To Unit" from the other list then, enter a figure in one cell of
the
worksheet to convert it from one unit to the other eg. Gallons to Litres.
In
the column next to the Units I have the requisite symbols eg, "gal" , "L"
etc.
Any ideas would be appreciated.
Regards,
--
TonyB