jack van oorsouw pretended :
Hello,
newby in xcel.
I am working on a userform.
in cell a1 you would select from list 1-25 a valua, this is put in cell a1.
Based on valua of a1 in a 2 would be a txt message.
example
a1 a2
1 text 1
2 text 2
3 text 3
etc
25 text 25
valua a1 is coming from selection list 1-25
what would be the eassiest way to set this up.

many thanks in advance
jack

Submitted via EggHeadCafe
ASP.NET Generic Cookie Utility Class
http://www.eggheadcafe.com/tutorials...ity-class.aspx

Well.., your use of the term 'easiest way to set this up' is a bit
ominous. You might be better off using a dropdown in the ColumnA and a
formula using the HLookup function in ColumnB (or wherever), where your
25 text values are stored in row2 of (hidden) rows(1:2) and your 1-25
value choices are stored in row1. Give Range("A1:Y2") a locally defined
name something like "TextChoices". Enter this formula in whatever
column to the right of Column("A") you want the result put into.

=HLOOKUP($A3,TextChoices,2,False)

Optionally, you could store the lookup range on a hidden sheet,
vertical or horizontal, and use VLOOKUP or HLOOKUP. Give the sheet a
name something like "TextValues" and edit the above formula as follows.

=HLOOKUP($A3,'TextValues'!TextChoices,2,False)
OR
=VLOOKUP($A3,'TextValues'!TextChoices,2,False)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc