How about Data Validation? Debra Dalgleish has details on her website at

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"snax500" wrote in message
...
In Excel2000, I have the following code in a macro...

NAME = Application.InputBox("Type in Name to be filtered")

I want the user to use a list box ( with references to
range("o34:o50") instead of InputBox, less chance for spelling errors.
How do I replace the code?

Thanks