Thank you for responding and for you help. I believe you are referring to my statement of "when user enter data..." when you ask about the data? I was referring to the number user inserts at the spin box in the userform. Everything from the proprietary database works fine, I have no problem with that. My only problem and main concern is repeating information/paragraphs in the doc per the number selected. That, I can't get to work. I can get it to work if I use If.. Then... Else but that's a lot to write. If 20 is selected, I don't want to use If... Then... Else 10 times. There has to be an easier way using either the Loop or For next and I am trying to do one of them.