A bit of background -- I am using VBA to allow users to save a selection of sheets in the workbook directly to PDF so automation is necessary for what I’m doing.
The screenshot I have attached shows one of the sheets that will be printed to PDF when the user presses a button elsewhere in the sheet. Currently, the user can fill in their ‘report details’ inside of a text box (at the bottom of the page) that I have sized to fit onto a single A4 piece of paper. The issue is that if the user wants to create a larger report and create additional ‘lines’ of text that exceed the pre-determined size of the text box, the text does not roll over onto a second page. It simply does not get displayed anywhere when the PDF is printed via VBA.
Is there any way (with standard text boxes, or active x forms) to automatically have the additional text that does not fit inside of the box on a second page simply roll over to a second page? I assume this would just involve using some sort of page break, but I’m really not sure how to accomplish this!
This is more of a strategy question. Does anyone have any suggestions that I can try to achieve my functionality goal?
Thanks so much in advance.
The screenshot I have attached shows one of the sheets that will be printed to PDF when the user presses a button elsewhere in the sheet. Currently, the user can fill in their ‘report details’ inside of a text box (at the bottom of the page) that I have sized to fit onto a single A4 piece of paper. The issue is that if the user wants to create a larger report and create additional ‘lines’ of text that exceed the pre-determined size of the text box, the text does not roll over onto a second page. It simply does not get displayed anywhere when the PDF is printed via VBA.
Is there any way (with standard text boxes, or active x forms) to automatically have the additional text that does not fit inside of the box on a second page simply roll over to a second page? I assume this would just involve using some sort of page break, but I’m really not sure how to accomplish this!
This is more of a strategy question. Does anyone have any suggestions that I can try to achieve my functionality goal?
Thanks so much in advance.
