See http://www.gmayor.com/Userform.htm which covers a variety of ways of inserting data from the userform. The code shown, has the process associated with the command button, but it is a simple substitution to add it to the macro I posted earlier instead.