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