On Mon, 18 Sep 2006 10:27:57 +0100, "Alex"
wrote:

Hi,

In Excel 2000, I am using an Input box for the users to enter some data.
However, my cell also has data validation on it. However when i enter data
via the input box, the data validation doesn't seem to work - is this right,
and is there a way round this?

Thanks

Yes, That's the way it works.

The workaround would be building similar data validation rules into a
macro which controls the input box.

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________