Thanks Norie - works like a charm. I didn't want to check everything at the end of entry Kylie123, because it is possible for the user to leave the form for another userform that depends on some data in the initail one (sorry to be confusing here...) but thanks for the reply.