ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how do I get a page 2 with inseted text box (https://www.excelbanter.com/excel-programming/353247-how-do-i-get-page-2-inseted-text-box.html)

jeramie[_2_]

how do I get a page 2 with inseted text box
 
I have a form with a text box in it (inserted where i
cut out some cells). When I get to the last line in the box, how do I get it
to make a "page 2", where the text continues at the top of the text box on
the second page? I need the Second page to be a copy of the first, but with
a blank text box.


JNW

how do I get a page 2 with inseted text box
 
in the text box change event put the following.(You'll need to change the
references to the textboxes and the multipage and also the limit of digits in
the first textbox).

If len(textbox1) = 255 then
Multipage1.value = 1
textbox2.setfocus
end if

"jeramie" wrote:

I have a form with a text box in it (inserted where i
cut out some cells). When I get to the last line in the box, how do I get it
to make a "page 2", where the text continues at the top of the text box on
the second page? I need the Second page to be a copy of the first, but with
a blank text box.



All times are GMT +1. The time now is 07:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com