Thread: Dropdown list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
snax500 snax500 is offline
external usenet poster
 
Posts: 49
Default Dropdown list

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