Hi Guys,

I dont even know if this is possible (although i'm slowly realising that anything and everything is possible in excel!)

I would like to validate all info which is entered into a column.

Data is account codes.

I would like to use a userform to check the codes as they are entered.

something like:

user types code in cell -

Userform appears with entry box and ok button.

User re enters code in form.

form checks data is identical to data originally entered in cell.

If they are the same, the data is entered into the cell.

If they are different the userform prompts the user to re enter value in cell and process starts again.

any ideas if this is do-able?

thanks