It's not necessary to have it in a cell, and it's not necessary that it be
numeric.
For instance:

Sub Testy()
a = "something"
Select Case a
Case Is = "something"
MsgBox "It's something!"
Case Is = "something else"
MsgBox "It's something else!"
Case Else
MsgBox "it's neither one"
End Select
End Sub

"Lenny" wrote in message
...
I develop electronic form templates in Word, however, I currently have the
opportunity to develop a shipping document in Excel. I want to insert a
dropdown in cell A1 that contains a single list of the companys plants.
Once
the plant has been selected from the dropdown, the appropriate address
will
proliferate cell A2. I do this using SelectCase in Word but I notice that
the construction of the code is different in Excel. I see that in Excel
the
items that populate the code need to be entered into a cell range on the
spreadsheet, workbook, or external document. I also note that the Select
case in Excel seems to ask for a 'numeric' value and the anticipated
returned
numeric value.....is there a counterpart I can use in Excel to get my
desired
results? Best regards - Lenny