Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to force text to rol to next cell
Guys/Gals:
A portion of a template I've created includes a section for users to enter free text. This section consists of eight rows. The idea is to enter text into each row in succession so it has a paragraph-type style. It works fine when the user hits the tab key before overwriting the end of the row. When they forget, it cuts off the end of his/her sentence. What I'd like to do is write a macro that recognizes when the user is near or has reached the end of the writable area of a particular row and automatically tabs to the next row. Maybe this could be done with some sort of cell width calculation. The code would then repeat itself until the user reached the end of the eighth row. In a perfect world, the code would function seamlessly with the user typing through all eight rows without any extra keystrokes. Any help would be greatly appreciated. P.S. I've already tried the text wrap alternative and was not satisfied with the look or results. --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to force text to rol to next cell
Macros don't run while editing. You would need to put up a userform and
gather the information in a textbox, then put it into your eight rows or reformat the users information after they completed entry in the worksheet using the change event perhaps. -- Regards, Tom Ogilvy "d_low" wrote in message ... Guys/Gals: A portion of a template I've created includes a section for users to enter free text. This section consists of eight rows. The idea is to enter text into each row in succession so it has a paragraph-type style. It works fine when the user hits the tab key before overwriting the end of the row. When they forget, it cuts off the end of his/her sentence. What I'd like to do is write a macro that recognizes when the user is near or has reached the end of the writable area of a particular row and automatically tabs to the next row. Maybe this could be done with some sort of cell width calculation. The code would then repeat itself until the user reached the end of the eighth row. In a perfect world, the code would function seamlessly with the user typing through all eight rows without any extra keystrokes. Any help would be greatly appreciated. P.S. I've already tried the text wrap alternative and was not satisfied with the look or results. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel save as csv - force text qualifier on every text field | Excel Discussion (Misc queries) | |||
Force Macro | Excel Discussion (Misc queries) | |||
How to force a wrap text function when the cell is big enough to p | Excel Discussion (Misc queries) | |||
How can I force certain text formatting in a cell? | Excel Discussion (Misc queries) | |||
force text in a cell based on value of cell in a range | Excel Programming |