RMCGAR
Mechanical
- Jul 20, 2006
- 5
I'm trying to automate the quote sheet at my office and have come up with a nice userform with that looks nice and has some vba code and is mostly efficient. The last problem that I would like to tackle is this:
First off the form has space for company name, quote, number, date, ect. then a table with a description of the part/service and a price. There is often a need for multiple pages and the description of one part/service may be longer then the space provided on one page. My goal is to be able to link the form field on one page provided for the part/service description to the one on the next page. So say you type a description of a part/service that takes up the entire space provided for the form field (on one page) and then you decide to go back and add a sentence to the begining, i would like the spill over text to be added to the begining of the formfield on the next page. Is this possible?
I hope this description was clear enough let me know if it was not.
I'm comfortable with basic VBA programming if that is necesarry.
Thank You,
Rory
First off the form has space for company name, quote, number, date, ect. then a table with a description of the part/service and a price. There is often a need for multiple pages and the description of one part/service may be longer then the space provided on one page. My goal is to be able to link the form field on one page provided for the part/service description to the one on the next page. So say you type a description of a part/service that takes up the entire space provided for the form field (on one page) and then you decide to go back and add a sentence to the begining, i would like the spill over text to be added to the begining of the formfield on the next page. Is this possible?
I hope this description was clear enough let me know if it was not.
I'm comfortable with basic VBA programming if that is necesarry.
Thank You,
Rory