in excel on the main menu acess the following menu

Tools>Macros>Macro Recorder

what this does is records Actions that your perform manually in Excel and
writes them into VBA code in a module for you.

So what you need to do is

run the macro recorder
setup your data validation
stop the macro recorder

Then in VBA editor, you should now have the proper syntax for the data
validation you need.




--
When you lose your mind, you free your life.


"Joe" wrote:

> Thanks a lot, Ben. I have more questions now:
>
> 1. What is a macro recorder? How can I access it?
>
> 2. My list is a bunch of strings - not numbers. What would I have to
> change to the above macro to achieve that?
>
> Thanks,
>
> Joe.
>
>