Mike: I'm not quite sure what you are trying to do. "TheList" isn't a
function; that's why you are getting the error. If, when you type "TheList"
into a cell, you would like "hello" to appear in the cell to right, you would
use a vlookup based on a list that you provide.
A B
1 TheList hello
2 mylist bye
3 yourlist tomorrow
4
5 TheList

In B5 you would type =vlookup(A5,A1:B3,2,FALSE)

"mikebres" wrote:

When I create my own function and place it in a cell I get a #NAME? error.
To test this further I created the simple function below. I entered
=TheList() in a cell. I still got the error. Any ideas why, or better yet
how do I fix it? Thanks - Mike

Function TheTest()
TheTest = "Hello"
End Function