Cancel that Andy........
I got it! Thanks for your help!
Corey Heidenreich




"Corey Heidenreich" wrote in message
...
Hey Andy,
Okay.........I've got my list in E1 thru E26.
I've named those cells as "Alpha"
In cell 'a1' I've done a 'list' validation equalling "alpha" so the drop
down shows there.
How do I get that validated cell to show the different numeric values (1
thru 26) when the alpha values are selected?

Corey



"Andy Wiggins" wrote in message
...
A will have to be A. What you can do is interpret that where you need 1 by
using a formula such as:
=CODE(UPPER(A1))-64
This assumes your list is in cell A1.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Corey Heidenreich" wrote in message
...
Hello All,
I'm trying to make a drop down list with alpha values (A thru Z) so that
if
you select "A", it'll show "A" in the cell but give it a value of 1.
Thus
if you select "B" in the dropdown, it'll show "B" however give it a
value
of
2 and so on.
Anyone have a VBA macro or excel equation that would work for this?
Corey