You can't have custom validation AND list validation. As you've discovered,
they are mutually exclusive. If you have list validation, the cell will only
accept entries on that list.

Create the list on your worksheet, then point to it by entering your range
of cells preceded by equals in the source field (eg =F7:F9).

I'm using Excel 2000 so the next bit may differ:

If your list is on another sheet or in another workbook, you will have to
create a named range and point to that in the source field instead (eg
=NamedRange).

Hope this helps.

--
Ian
--

"rwbaker" wrote in message
...
excel 2003
I have several cells that I have some custom data validation configured
I also want to have a in-cell drop down list for these cells

Can some please tell me how I can do this

I go to the data - validation and select list but it seems to take away
the
custom data valadation I have