Forum Discussion
Problem with text toolbox in connection with printing
I have created an excel form in O365. There i have set a text toolbox with (steuerelement) a scrollbar. to be able to enter a lot of text. If I enter now much text, so that the scrollbar becomes ac...
To be honest, I don't know a really solid solution for this. We could:
1. Remember the tops of each textbox and move textboxes 2-n down if needed
2. If a textbox becomes taller than a given number, first remember its width and make it wider before setting it to autosize
Option 1 may mean the textbox spills to a next sheet of paper when printing (Don't even know if the last one will print if it spills over if your print area is too small?)
Option 2 will nog guarantee they don't overlap
Excel is not the best program to use when it comes to printing large amounts of texts. More than ~1000 characters quickly becomes cumbersome.
1. Remember the tops of each textbox and move textboxes 2-n down if needed
2. If a textbox becomes taller than a given number, first remember its width and make it wider before setting it to autosize
Option 1 may mean the textbox spills to a next sheet of paper when printing (Don't even know if the last one will print if it spills over if your print area is too small?)
Option 2 will nog guarantee they don't overlap
Excel is not the best program to use when it comes to printing large amounts of texts. More than ~1000 characters quickly becomes cumbersome.
Good Morning,
thx for your great support. At the weekend i´m created a form with ms word. I think it is the better way to solve my problems - an what should i say -> it work`s.
I'am thankfull of your help.
Best regard´s
Steffen Verfürth
- Excellent, glad you were able to solve the issue.
