Hi,

Can anyone help me please ?

What I’m trying to do is to ensure a user inputs data into a series of cells correctly e.g.

If the user inputs data (numbers or text) in any cell say from A1 through to cell A20 that if they omit to input any data into any of the cells that they get a warning message to rectify.

I have already used the validation facility to check if the input has exceed the desired character length required, so I would be grateful for any assistance for a VB solution to check for data input and also incorporate the field length check.

Excel Version 2000


Many thanks


Rob