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