I have created a userform with all the command buttons and 7 textboxes and Itried your code (roughtly). I did not encountered any problems with the cmdAdd.What is it that is not working? could you give more details.