 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2008"Make text continue from worksheet 1 onto worksheet 2"
I have 3 sheets and on sheet 1 I have two sections for comments. Each comment section has 13 rows that have columns A-I merged. On sheet 2 I also have two comment sections using the same column setup but with 23 rows. At the end of the 13th row on sheet 1 for each section, I want the text to continue automatically onto sheet 2 per each section. The Excel form will be stored on a shared drive. I also want sheet 2 to print onto the back of sheet 1 no matter who prints off any printer and all our printers have book printing available. I don't want to have to change the printer setting each time I print the form. I have a similar problem of trying to wrap text to a separate, non adjacent cell when the first is full. Any help would be appreciated. Thanks! > I have 3 sheets and on sheet 1 I have two sections for comments. Each comment > section has 13 rows that have columns A-I merged. On sheet 2 I also have two [quoted text clipped - 5 lines] > off any printer and all our printers have book printing available. I don't > want to have to change the printer setting each time I print the form. How will Excel know the cell is full? Gord Dibben MS Excel MVP >I have a similar problem of trying to wrap text to a separate, non adjacent >cell when the first is full. Any help would be appreciated. Thanks! Good question. I guess I would also have to know how to limit the amount of text in each cell. I have been trying VB code with MaxLenth and AutoTab, but have not been successful yet. If anyone knows how to write these subs,macros,properties, or however they should be set up to be effective, please let me know! Thanks! > How will Excel know the cell is full? > > Gord Dibben MS Excel MVP > > >I have a similar problem of trying to wrap text to a separate, non adjacent > >cell when the first is full. Any help would be appreciated. Thanks! Macros won't run while you're entering a value/formula in a cell. So that approach won't work. You could use data|validation, but it only catches restrictictions when the user tries to leave the cell (or hit enter). This probably wouldn't work the way you'd like. One approach may be to design a userform with a textbox that gets the value from the user. You can determine the length of the textbox after each change the user makes. When the limit is reached, you could do what you want. Here are a couple of references: Debra Dalgleish's site: Http://contextures.com/xlUserForm01.html and these articles by Peter Aiken: http://msdn2.microsoft.com/en-us/library/aa155729(office.10).aspx http://msdn2.microsoft.com/en-us/library/aa155610(office.10).aspx > Good question. I guess I would also have to know how to limit the amount of > text in each cell. I have been trying VB code with MaxLenth and AutoTab, but [quoted text clipped - 8 lines] > > >I have a similar problem of trying to wrap text to a separate, non adjacent > > >cell when the first is full. Any help would be appreciated. Thanks!  SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.