geekgirlau, no I don't enjoy checking for all the possible wrong entries a user can enter, but I do my error checking mostly in another macro that is called. This is the one test I'm doing in the "mother" macro. I find that creating a userform is just too time consuming unless I REALLY have an application that requires it. In fact I haven't created a single userform since I started using Win XP. In Win 98 SE it was my experience that userforms used a LOT of resources in addition to being a pain to create. So I usually don't create them.