On Thu, 10 Sep 2009 10:16:11 -0700, ker_01 wrote:

You are very welcome. I've gained so much assistance from this group over the
years, I'm glad when I can help others out.

Unfortunately, I don't have an answer to your final question- I only figured
out that it was necessary to add the value through trial and error. It seems
that I can enter data validation directly through the Excel interface without
a problem, but (at least under an unknown set of conditions) adding the data
validation via VBA requires the valid entry. I wish I had a more informative
answer for you.

Best,
Keith

It's a good thing to know. I never would have tried that on my own.

Thanks again for your help. The spreadsheet is now ready to go to the end
users and I think it'll make everyone's life a little easier because the
person entering the data will be getting feedback if they make errors as
they enter it, rather than a week or more later after we've had time to
review it up here.