Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell to cell
Here's what I'm trying to accomplish. I have a worksheet setup where the
user inputs their daily activities. The daily activities area is made up of 5 rows merged accross the page. I have them set to fixed width as to not grow. What I need to happen is when they have typed enough information to fill the row, it have it go to the next row automaticly, then the next until the last row is fill. But if there is addtional information past the worksheet's five rows then go to worksheet 2 and continue in the same manner. can this be done? I don't want to use the alt+enter event because I'm not the one typing the information. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell to cell
I don't think you'll find anything like this built into excel.
Maybe you could build some sort of userform that counts characters and puts data where you want it. (it might be lots more trouble than it's worth.) Renegade40 wrote: Here's what I'm trying to accomplish. I have a worksheet setup where the user inputs their daily activities. The daily activities area is made up of 5 rows merged accross the page. I have them set to fixed width as to not grow. What I need to happen is when they have typed enough information to fill the row, it have it go to the next row automaticly, then the next until the last row is fill. But if there is addtional information past the worksheet's five rows then go to worksheet 2 and continue in the same manner. can this be done? I don't want to use the alt+enter event because I'm not the one typing the information. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell to cell
Hi Dave
What do you mean by Userform how is this done. I have enherited this project and am not really familier with excell. Mainly use quark-express a long way from this. any information would be greatly appreciated. "Dave Peterson" wrote: I don't think you'll find anything like this built into excel. Maybe you could build some sort of userform that counts characters and puts data where you want it. (it might be lots more trouble than it's worth.) Renegade40 wrote: Here's what I'm trying to accomplish. I have a worksheet setup where the user inputs their daily activities. The daily activities area is made up of 5 rows merged accross the page. I have them set to fixed width as to not grow. What I need to happen is when they have typed enough information to fill the row, it have it go to the next row automaticly, then the next until the last row is fill. But if there is addtional information past the worksheet's five rows then go to worksheet 2 and continue in the same manner. can this be done? I don't want to use the alt+enter event because I'm not the one typing the information. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell to cell
A userform looks like one of those dialogs that you may find under
Tools|options. If you look at Tools|Options|General tab, you'll see a few textboxes. You could pop up a userform and have your code behind that userform that reformats the value the user entered into strings no longer than 50 characters. If you want to learn more about userforms: Check Debra Dalgleish's site: http://contextures.com/xlUserForm01.html and these articles by Peter Aiken: http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx Renegade40 wrote: Hi Dave What do you mean by Userform how is this done. I have enherited this project and am not really familier with excell. Mainly use quark-express a long way from this. any information would be greatly appreciated. "Dave Peterson" wrote: I don't think you'll find anything like this built into excel. Maybe you could build some sort of userform that counts characters and puts data where you want it. (it might be lots more trouble than it's worth.) Renegade40 wrote: Here's what I'm trying to accomplish. I have a worksheet setup where the user inputs their daily activities. The daily activities area is made up of 5 rows merged accross the page. I have them set to fixed width as to not grow. What I need to happen is when they have typed enough information to fill the row, it have it go to the next row automaticly, then the next until the last row is fill. But if there is addtional information past the worksheet's five rows then go to worksheet 2 and continue in the same manner. can this be done? I don't want to use the alt+enter event because I'm not the one typing the information. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |