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

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

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

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

Another Quick Question......
What if the alpha values were actually people names, or city names......but
yet you wanted to use the numeric values for those?
How would that work?
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

The Function CODE only deals with the first character in the string. So the
formula "=CODE(UPPER(A1))-64" will still produce a (1) even if cell A1
contains the word "Alphabet". Does this help?

Mike F

"Corey Heidenreich" wrote in message
...
Another Quick Question......
What if the alpha values were actually people names, or city
names......but yet you wanted to use the numeric values for those?
How would that work?
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

If your list is in the range B1:B5 and the dropdown is in cell A1 then use:

=MATCH(A1,B1:B5,0)

You could have used something similar for your original question.

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

"Corey Heidenreich" wrote in message
...
Another Quick Question......
What if the alpha values were actually people names, or city
names......but
yet you wanted to use the numeric values for those?
How would that work?
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