Thank you soooo much for your help.......its working now.
One more thing I need to add in userform:
Whenever I open the document, userform pops up and the text boxes are blank.
Is it possible that textboxes retains the value i have entered earlier, if i need to edit the values then i can otherwise no need to enter the values again and again.
[quote name='StuartR' post='769009' date='03-Apr-2009 16:32']You really are going to have to post your template so we can see what you have done.[/quote]